Gwen Shapira
@gwenshap.bsky.social
Founder of SaaS Developer Community and Nile Database.
My favorite ritual on the calendar :)
September 30, 2025 at 9:04 PM
My favorite ritual on the calendar :)
Love it! Such a gorgeous collection.
July 3, 2025 at 1:35 AM
Love it! Such a gorgeous collection.
It’s been 22 years and I’m still madly in love with my husband.
June 27, 2025 at 2:02 AM
It’s been 22 years and I’m still madly in love with my husband.
Maybe it’s from reading the news? Social media?
June 10, 2025 at 3:56 AM
Maybe it’s from reading the news? Social media?
Definitely. Descript is such a time saver for these things.
June 10, 2025 at 3:56 AM
Definitely. Descript is such a time saver for these things.
Never mind. Looks like I remembered linear algebra wrong and matrices are strictly 2-dim.
May 30, 2025 at 9:50 PM
Never mind. Looks like I remembered linear algebra wrong and matrices are strictly 2-dim.
Why aren't these called Matrixes? Like multi-dimensional vectors were called back when I did linear algebra?
May 30, 2025 at 9:47 PM
Why aren't these called Matrixes? Like multi-dimensional vectors were called back when I did linear algebra?
I made a note to try this next time I have a problem query to debug :)
May 30, 2025 at 2:53 AM
I made a note to try this next time I have a problem query to debug :)
Nice! I wasn't familiar with this paper. Thank you!
May 29, 2025 at 10:37 PM
Nice! I wasn't familiar with this paper. Thank you!
🛠️ 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.
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.
May 29, 2025 at 8:06 PM
🛠️ 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.
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...
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...
May 29, 2025 at 8:06 PM
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...
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...
omg, this is so purrfect!
May 29, 2025 at 5:36 PM
omg, this is so purrfect!