Postgres Gotchas | Postgres.FM 119 |

Описание: [ 🇬🇧_🇺🇸 Check out the subtitles – we now edit them, ChatGPT+manually! You can also try YouTube's auto-translation of them from English to your language; try it and share it with people interested in Postgres!]

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-th...
Postgres Gotchas (list by Ian Barwick) https://sql-info.de/postgresql/postgr...
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/1844...
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/...
vacuumdb https://www.postgresql.org/docs/curre...
vacuum_cost_delay https://www.postgresql.org/docs/curre...
Zero-downtime Postgres schema migrations need lock_timeout and retries (blog post by Nikolay) https://postgres.ai/blog/20210923-zer...
Postgres Hacking 101: adding params, prevent_unqualified_deletes and prevent_unqualified_updates    • Postgres Hacking 101: adding params, preve...  
PostgREST suggestion to use pg-safeupdate https://docs.postgrest.org/en/v12/int...
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 in the comments, or by tweeting us on @postgresfm   / postgresfm  , @samokhvalov   / samokhvalov   and @michristofides   / michristofides  


~~~


Postgres FM is produced by:
Nikolay Samokhvalov, founder of Postgres.ai https://postgres.ai/
Michael Christofides, founder of pgMustard https://pgmustard.com/


~~~


This is the video version. Check out https://postgres.fm to subscribe to the audio-only version, to see the transcript, guest profiles, and more.