A foreign key pathology to avoid
Popular streamers and millions of concurrent viewers expose a PostgreSQL anti-pattern: bulk inserts on foreign keys trigger MultiXact overflow and brutal lock…
OK, sometimes you can lock tables.
Schema changes on busy tables can deadlock your system. Use LOCK TABLE NOWAIT in a retry loop to avoid blocking the queue behind your ALTER TABLE.
How slow is DECIMAL, anyway?
NUMERIC is 2–5x slower than DOUBLE PRECISION in arithmetic operations, but not absurdly so.
Why submit a paper to PgDay 2020?
Have a PostgreSQL story to share? PgDay 2020's Call for Proposals welcomes first-time speakers and fresh perspectives from the community.
PgDaySF 2020!
The inaugural PgDay San Francisco lands January 21 at the Swedish-American Hall. Call for proposals and early-bird tickets are now open.
“Look It Up: Practical PostgreSQL Indexing” at Nordic PGDay 2019
Slides from my PGDay Nordic 2019 talk on lookups are now online—dive into the techniques that made the presentation.
What’s up with SET TRANSACTION SNAPSHOT?
PostgreSQL lets you export transaction snapshots so multiple sessions see the exact same database view—essential for tools like parallel pg_dump that need…
Do not change autovacuum age settings
PostgreSQL's autovacuum freeze parameters prevent catastrophic transaction ID wraparound—and cranking them up is a mistake that can force your database…
“Breaking PostgreSQL at Scale” at FOSDEM 2019
Discover what breaks when PostgreSQL scales to its limits, straight from the FOSDEM 2019 talk slides.
Find the value of all database sequences
Check your sequences for overflow risk without incrementing them. A handy PL/pgSQL function returns all current sequence values at a glance.