UUIDs vs serials for keys
UUID vs bigint: they're really two separate choices.
“Database Patterns and How to Find Them” at SCaLE 2023
Discover the database design mistakes that haunt production systems—and how to spot them before they cost you.
“Extreme PostgreSQL” at PgDay/MED
Join us in Malta as we explore PostgreSQL pushed to its limits and beyond.
Xtreme PostgreSQL!
Slides from the February 2023 SFPUG talk are now available—grab them to dive into what was discussed.
Nordic PgDay 2023
Logical replication in PostgreSQL can seem straightforward in theory but presents real challenges in production.
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.