· 5 min read
The pgvector index nobody measured
Vector search in Postgres degrades quietly. The index crosses RAM, the build runs on disk, recall decays with churn, and none of it raises an alert.
Read the post →
Blog
#postgres-internals
· 5 min read
PostgreSQL 18 moved the WAL I/O counters
pg_stat_wal lost its write and sync columns to pg_stat_io in 18. Nothing errors. The numbers just stop arriving, and most monitoring never notices.
Read the post →
· 5 min read
75% of our query-plan storage was duplicate
Thousands of stored plans turned out to be a few hundred distinct shapes. What a structural fingerprint keeps, what it strips, and why regressions depend on it.
Read the post →
Follow this topic on its own: #postgres-internals RSS feed. All topics are listed on the topics page.