Rethinking PostgreSQL Storage
a year ago
- #postgresql
- #nvme-ssd
- #cloud-storage
- Cloud storage was initially designed around the limitations of old hardware like HDDs.
- Modern NVMe SSDs offer 2.5 million IOPS for $600, compared to $1.3M/month for similar performance on Aurora.
- Local NVMe SSDs are faster, cheaper, and more reliable than network-attached storage.
- Cloud providers historically used network-attached storage for durability and scalability.
- NVMe SSDs connect directly over PCIe, reducing latency and enabling parallel data paths.
- Network-attached storage still offers elasticity and durability advantages.
- Ubicloud benchmarks show PostgreSQL performs 1.4x better on NVMe than Aurora and 4.6x better than RDS.
- TPC-H benchmarks show Ubicloud with NVMe is 2.42x faster than Aurora and 2.96x faster than RDS.
- Local NVMe SSDs are the future for cloud databases, especially for data-intensive applications like PostgreSQL.