#605 — June 26, 2025 |
|
Postgres Weekly |
|
|
Interesting Bits of Postgres Grammar — Steve has been building a linter for Postgres migrations and has had to dig into some of the curiosities of grammar Postgres supports with a mix of standard SQL and Postgres-only approaches. Steve Dignam |
How Notion Runs PostgreSQL at Scale — Notion achieved a 733% performance improvement on a critical query by refining a single GIN index. Read how they scaled Postgres across 96 shards and resolved production issues faster with pganalyze. pganalyze sponsor |
|
PLJS 1.0: JavaScript Language Plugin for Postgres — PLV8 has been the ‘go to’ way to use JavaScript as a procedural language within Postgres for years, but this QuickJS-based variant, from the same creator, has a much lighter footprint, is easier to maintain, and may be enough for your needs. Jerry Sievert |
|
IN BRIEF:
|
|
▶ Performance Archaeology - 20 Years of Improvements — A talk looking at performance changes in Postgres over the years, all the way from Postgres 8.0 (released in 2005) to now. It’s amazing to see how much we’ve gained over time, though big jumps in performance have slowed down since Postgres 11. Tomas Vondra |
💡 If you'd rather read about this work, Tomas has a blog post about what he did here. |
|
📄 Debugging Memory Leaks in Postgres – Jemalloc Edition – Phil continues with his deep dives into debugging memory leaks. Phil Eaton 📄 Which HA Solution Fits Your Needs: Pgpool or Patroni? Semab Tariq 📄 The Differences Between OrioleDB and Neon Alexander Korotkov |
✂︎ Deep Cuts from the Queue |
|
Each day, we add interesting finds to a running queue of potential newsletter items. Not everything makes the cut each week, though, so the queue quietly grows. This week, we’ve dug back through and picked out a few highlights we think are still worth sharing:
|