Postgres Gotchas

Nikolay and Michael discuss some Postgres Gotchas, things you might expect to work one way in fact working another way.

Here are some links to things they mentioned:
• Our episode on NULLs postgres.fm/episodes/nulls-the-good-the-bad-th…
• Postgres Gotchas (list by Ian Barwick) sql-info.de/postgresql/postgres-gotchas.html
• Our episode on slow count postgres.fm/episodes/slow-count
• Discussion on X about major version upgrades and statistics x.com/samokhvalov/status/1844593601638260850
• Our episode on upgrades postgres.fm/episodes/upgrades
• Statistics Import and Export (commitfest entry which link to email thread) commitfest.postgresql.org/50/4538
• vacuumdb postgresql.org/docs/current/app-vacuumdb.html
• vacuum_cost_delay postgresql.org/docs/current/runtime-config-res…
• Zero-downtime Postgres schema migrations need lock_timeout and retries (blog post by Nikolay) postgres.ai/blog/20210923-zero-downtime-postgr…
• Postgres Hacking 101: adding params, prevent_unqualified_deletes and prevent_unqualified_updates youtube.com/watch?v=samLkrC5xQA
• PostgREST suggestion to use pg-safeupdate docs.postgrest.org/en/v12/integrations/pg-safe…
• DBOS (new company co-founded by Michael Stonebraker) dbos.dev

~~~
What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, (postgres.fm/people) or by commenting on our Google doc (docs.google.com/document/d/1PNGSn_d0A7gTR4C0p6…)!

~~~
Postgres FM is produced by:
• Michael Christofides, founder of pgMustard (pgmustard.com)
• Nikolay Samokhvalov, founder of Postgres.ai (postgres.ai)

With special thanks to:
• Jessie Draws for the elephant artwork