Vindicating ZFS with PostgreSQL: Unleashing the Power of Scalability
summary
Real-world GCP tests use Rocky Linux 9.3, PostgreSQL 16.2 on an e2-highmem-8 with separate SSD volumes and pgbench: pgbench sf500 with 50 clients for 120s. Ext4 runs ~4,900 TPS (5371 with noatime). ZFS starts at ~1,700 TPS but with lz4 compression cuts space from 7.4GB to <1GB and performance improves; tuning the recordsize 16K pushes TPS to ~6,200, outpacing tuned ext4. Adding a ZIL or changing arc/txg tuning gives little extra benefit.
AI-written summary · about
chapters (8)
- 0:00Intro with jazz music composed by Federico!
- 4:07Start of real-world customer story
- 6:38About Postgres
- 7:16About Linux
- 9:22Gently pushing Postgres & Linux together
- 12:17File systems
- 13:32Enter ZFS
- 16:57Testing and performance
related talks
35mVindicating ZFS with PostgreSQL: Unleashing the Power of Scalability
50mPostgres vs. Linux filesystems
51mPostgreSQL on ZFS
36mBest Practices in PostgreSQL Tuning: Navigating Key Performance Bottlenecks in the Cloud
46mUnlock PostgreSQL’s True Performance with Local SSDs
36mAutomated Performance Testing of Postgres
32mOn compression of everything in Postgres
43mPostgreSQL in the cloud: Theory and Practice