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-only
- Our episode on BRIN indexes https://postgres.fm/episodes/brin-indexes
- Tips to Improve Insert Performance https://www.timescale.com/blog/13-tips-to-improve-postgresql-insert-performance/
- Our episode on WAL and checkpoint tuning https://postgres.fm/episodes/wal-and-checkpoint-tuning
- autovacuum_vacuum_insert_scale_factor https://www.postgresql.org/docs/current/runtime-config-autovacuum.html#GUC-AUTOVACUUM-VACUUM-INSERT-SCALE-FACTOR
- Our episode about compression https://postgres.fm/episodes/compression
- New project announced recently called BemiDB https://x.com/samokhvalov/status/1854726389603484145
- 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 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