iiinova — where your digital self keeps evolving

Gwen Shapira @gwenshap.bsky.social · 27/06/2025

It’s been 22 years and I’m still madly in love with my husband.

P(aul) Frazee @pfrazee.com · 16/06/2025

Reposted by Gwen Shapira

I use a spreadsheet to track all my documentation It's important to keep all your docs in a row

3658922

Gwen Shapira @gwenshap.bsky.social · 10/06/2025

Maybe it’s from reading the news? Social media?

130

Gwen Shapira @gwenshap.bsky.social · 10/06/2025

Definitely. Descript is such a time saver for these things.

020

Gwen Shapira @gwenshap.bsky.social · 10/06/2025

Videos from PgConfDev are starting to show up on YouTube! Great time to catch up on both the new content and the amazing talks from past events. You can start with my talk: "Scaling Postgres to Million Tenants" www.youtube.com/watch?v=EfAS...

youtube.com

Re-engineering Postgres for Millions of Tenants (PGConf.dev 2025)

YouTube video by PostgreSQL Development Conference

0152

Never mind. Looks like I remembered linear algebra wrong and matrices are strictly 2-dim.

130

Why aren't these called Matrixes? Like multi-dimensional vectors were called back when I did linear algebra?

210

So, Tensor (as in Pytorch) is just like a vector, except that it is somehow better for GPUs? Did I get that right?

160

I made a note to try this next time I have a problem query to debug :)

020

Nice! I wasn't familiar with this paper. Thank you!

000

🛠️ Unused index debug flow: ANALYZE ➜ rethink predicate ➜ simplify query ➜ audit policies & GUCs ➜ If still wrong, try pg_hint_plan (force an index to prove a point) or hypopg (hypothetical indexes) before filing a bug.

1️⃣ Stale stats: ANALYZE hasn’t run; filter looks un-selective. 2️⃣ Truly un-selective: Stats are right; scan really is cheaper. 3️⃣ Complex estimates: Many joins / ORs / CTE / functions scramble row estimates. 4️⃣ Handcuffs on: RLS limits optimizations or GUCs forbid the path. 5️⃣ Planner bugs: Rare but...

283

Tanel Poder @tanelpoder.com · 28/05/2025

“Why is Postgres seq-scanning rather than use this index?” 🤯 Short answer: the planner thinks that index won’t help (or can’t use it). Longer answer—5 usual suspects 👇

2121

Reposted by Gwen Shapira

New blog: Using Postgres pg_test_fsync tool for testing low latency writes An easy to use tool that comes with standard Postgres installation, for testing write latency of devices where you put your WAL/redo logs and any other files requiring low write latency. (link in reply)

295

Reposted by Gwen Shapira

Paul Ramsey @pwramsey.bsky.social · 25/05/2025

I feel like I've found a new controlling meme for open source contribution and innovation.

05210

Gwen Shapira @gwenshap.bsky.social · 23/05/2025

Thank you! I'll check out context7

010

Reposted by Gwen Shapira

schrepfler.bsky.social @schrepfler.bsky.social · 22/05/2025

I've registered it with context7 so it's now available as up-to-date nile documentation via the context7 MCP context7.com/www.thenile....

context7.com

Context7 - Up-to-date documentation for LLMs and AI code editors

Generate context with up-to-date documentation for LLMs and AI code editors

121

Gwen Shapira @gwenshap.bsky.social · 20/05/2025

🚨 New blog alert: Postgres 18 beta 1 was released last week, and includes native support for UUIDv7. Great opportunity to explain why UUIDv7 is a great fit for your database keys, and show you how to use them in PG18. www.thenile.dev/blog/uuidv7

1134

Gwen Shapira @gwenshap.bsky.social · 17/05/2025

אבל איך הוא כל כך יפה?

110

Gwen Shapira @gwenshap.bsky.social · 11/05/2025

mmm... my husband is Omer Shapira and he sure talks about memory safety non-stop.

110

Gwen Shapira @gwenshap.bsky.social · 07/05/2025

So funny. When I was a kid in Israel, the game was known as "Hertzel amar". (Hertzel said, presumably after the legendary zionist leader).

Gwen Shapira @gwenshap.bsky.social · 05/05/2025

כן. היום 81 מעלות ויהיה נעים, אולי טיפלה חם (אני מעדיפה 75).