Run PostgreSQL in Warp Speed Using NVMe/TCP in the Cloud
Talkat Data on Kubernetes Day North America 2023 · on Monday, 2023-11-06· at 11:40· W471ab, McCormick Place·
summary
Demonstrates running PostgreSQL on OpenShift in AWS using NVMe over TCP across three instance-store nodes and reports results from six 30-minute sysbench runs (averaged) using the Sherlock benchmark; compares throughput and cost against AWS IO2 Block Express, shows materially higher transaction rates and lower $/transaction, and cites 10–20x better latency/IO performance versus iSCSI while detailing CSI usage, low-cache test settings, and an end-to-end live demo.
AI-written summary · about
chapters (8)
- 0:00Introduction to NVMe
- 1:30Evolution of storage fabrics
- 3:21Overview of NVMe over TCP
- 7:30Why move to NVMe over TCP
- 10:20Performance testing setup
- 15:11Analyzing performance data
- 18:27Conclusions and takeaways
- 20:03Detailed Q&A session
related talks
10mPostgres on AWS: Run 5X faster on metal, migrate anywhere
43mPostgreSQL in the cloud: Theory and Practice
46mUnlock PostgreSQL’s True Performance with Local SSDs
27mPostgres isn’t slow, your storage is
36mBest Practices in PostgreSQL Tuning: Navigating Key Performance Bottlenecks in the Cloud
42mPostgreSQL Distributed: Architectures & Best practices
50mUnleashing the Power of Azure for PostgreSQL
50mPostgres vs. Linux filesystems