Append-only tables

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 en.wikipedia.org/wiki/Append-only
• Our episode on BRIN indexes postgres.fm/episodes/brin-indexes
• Tips to Improve Insert Performance timescale.com/blog/13-tips-to-improve-postgres…
• Our episode on WAL and checkpoint tuning postgres.fm/episodes/wal-and-checkpoint-tuning
• autovacuum_vacuum_insert_scale_factor postgresql.org/docs/current/runtime-config-aut…
• Our episode about compression postgres.fm/episodes/compression
• New project announced recently called BemiDB x.com/samokhvalov/status/1854726389603484145
• pg_tier github.com/tembo-io/pg_tier

~~~
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