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 https://postgres.fm/episodes/nulls-the-good-the-bad-the-ugly-and-the-unknown
• Postgres Gotchas (list by Ian Barwick) https://sql-info.de/postgresql/postgres-gotchas.html
• Our episode on slow count https://postgres.fm/episodes/slow-count
• Discussion on X about major version upgrades and statistics https://x.com/samokhvalov/status/1844593601638260850
• Our episode on upgrades https://postgres.fm/episodes/upgrades
• Statistics Import and Export (commitfest entry which link to email thread) https://commitfest.postgresql.org/50/4538/
• vacuumdb https://www.postgresql.org/docs/current/app-vacuumdb.html
• vacuum_cost_delay https://www.postgresql.org/docs/current/runtime-config-resource.html#GUC-VACUUM-COST-DELAY
• Zero-downtime Postgres schema migrations need lock_timeout and retries (blog post by Nikolay) https://postgres.ai/blog/20210923-zero-downtime-postgres-schema-migrations-lock-timeout-and-retries
• Postgres Hacking 101: adding params, prevent_unqualified_deletes and prevent_unqualified_updates https://www.youtube.com/watch?v=samLkrC5xQA 
• PostgREST suggestion to use pg-safeupdate https://docs.postgrest.org/en/v12/integrations/pg-safeupdate.html#pg-safeupdate
• DBOS (new company co-founded by Michael Stonebraker) https://www.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, or by commenting on our Google doc!

~~~

Postgres FM is produced by:

• Michael Christofides, founder of pgMustard
• Nikolay Samokhvalov, founder of Postgres.ai

With special thanks to:

• Jessie Draws for the elephant artwork