Append-only tables | Postgres.FM 123 | скачать в хорошем качестве

Append-only tables | Postgres.FM 123 |

[ 🇬🇧_🇺🇸 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 append-only tables in Postgres — what they are, some unique challenges they bring, and some options for compressing / removing / offloading the data eventually. Here are some links to things they mentioned: Append-only https://en.wikipedia.org/wiki/Append-... Our episode on BRIN indexes https://postgres.fm/episodes/brin-ind... Tips to Improve Insert Performance https://www.timescale.com/blog/13-tip... Our episode on WAL and checkpoint tuning https://postgres.fm/episodes/wal-and-... autovacuum_vacuum_insert_scale_factor https://www.postgresql.org/docs/curre... Our episode about compression https://postgres.fm/episodes/compression New project announced recently called BemiDB https://x.com/samokhvalov/status/1854... pg_tier https://github.com/tembo-io/pg_tier ~~~ 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.