Gwen Shapira

@gwenshap.bsky.social

Founder of SaaS Developer Community and Nile Database.

Introducing the pgconf.dev 2026 conference t-shirt! 🐘🎉 This year we're celebrating 30 years of PostgreSQL, and Slonik is dressed for the occasion. The only way to get one? Be there. See you in Vancouver, May 19–22.

Bild

I'm so excited to go on Talking Postgres! One of my fav podcasts! I'll chat about my journey to found Nile and discover Postgres. The podcast has a Discord channel where fans discuss the episode as it is recorded. If you want to join ua live, let me know and I'll send you an invite.

Bild

Tuesday is community engagement day 🐘 Hot take: it is the best day! Full of panels and discussions. Whether you're a first-timer or a longtime contributor, there's a seat at the table. Schedule (more sessions still being added!) → https://2026.pgconf....

Bild

The pgconf.dev 2026 schedule is stacked 🐘✨ WAL internals, query planning, logical replication, temporal data, columnar storage, 30 years of Postgres retrospective… and cake cutting. Something for every Postgres nerd. Full schedule → https://2026.pgconf....

Bild

PGConf.dev 2026: top things to do at the conference: • Debate MVCC trivia with strangers • Discover a feature you didn’t know you needed • Realize you’re not the only one who reads pg_waldump for fun Registration and CFP are open.

Bild

CFP for PGConf.dev 2026 is open until Jan 16 🐘 Tips for strong proposals: • Share what you discovered. Not just what you built. • Be specific • Discuss bigger Postgres picture • Failures welcome Be specific, connect to Postgres internals, and don’t hide the messy bits.

Bild

“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 👇

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)

Bild

You know the advice to say "thank you" instead of "sorry"? It looks like ChatGPT took it to heart. Me: You just said something incorrect. ChatGPT: Thank you for keeping it precise.

Folks at Google: there's no longer a button to get the PDF of your research papers directly from your website. Instead you have to do a hop through Google Scholar. Is that intentional? Seems worse than it used to be before.

Screenshot of the Percolator paper on the Google Research website. There are buttons for "Google Scholar" and "Copy Bibtex", but none to download the actual paper!

Running TPC-C can be a bit challenging. Running pgbench is easy (it ships with Postgres and uses simple Postgres configs), but its main built-in script is TPC-B. Thankfully, Ryo Kanbayashi wrote a pgbench script that is TPC-C-like: github.com/ryogrid/tpcc...

GitHub - ryogrid/tpcc_like_with_pgbench: Simplified version of the TPC-C benchmark using pgbench custom scripts

Simplified version of the TPC-C benchmark using pgbench custom scripts - ryogrid/tpcc_like_with_pgbench

github.com

What great engineering looks like: invisible at most times… except when it matters. Had no idea an iPhone would measure water presence on a charging port and warn for it. But it does! Was at a pool and a few hours later when plugging it in got this helpful message.

Bild