Massive DELETEs | Postgres.FM 093 |
[ 🇬🇧_🇺🇸 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 doing massive DELETE operations in Postgres — what can go wrong, how to prevent major issues, and some ideas to minimise their impact.
Here are some links to things they mentioned:
Article based on Nikolay’s talk, including batching implementation (translated to English) https://habr-com.translate.goog/en/ar...
Our episode on WAL and checkpoint tuning https://postgres.fm/episodes/wal-and-...
Egor Rogov’s book on Postgres Internals (chapter 10 on WAL) https://edu.postgrespro.com/postgresq...
full_page_writes https://www.postgresql.org/docs/curre...
TRUNCATE https://www.postgresql.org/docs/curre...
Our episode on partitioning https://postgres.fm/episodes/partitio...
Our episode on bloat https://postgres.fm/episodes/bloat
Our episode on index maintenance https://postgres.fm/episodes/index-ma...
~~~
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 brought to you 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.