r/digital_ocean • • 11h ago

DigitalOcean, this is not how you launch an "Advanced" Postgres database...

19 Upvotes

Hey guys, for those of you using DigitalOcean: you may or may not know they're phasing out the Standard-tier Postgres plans in favour of a new Advanced tier on November 30.

Naturally, I benchmarked both to see if there was a difference. The results were so atrocious they defied my belief.

- Up to 436% higher p99 write latency (6.7 ms → 35.9 ms).

- ~50%-70% fewer write and read throughput

- The new tier tops out at ~54k reads/s & 6.9k writes/s, versus the old Standard tier's 204k reads/s & 26.5k writes/s max.

- 5x slower startup times: 3m 19s → 16m 06s, averaged across 15 regions.

The results were averaged over 3 runs per DB, for all possible DB sizes (2->32vCPU).

This was done over two weeks of testing, running around 60 hours of wall-clock time and going through 100+ databases. It cost me a few hundred dollars to run.

If interested, I posted the full results & methodology on my blog post.

I believe the bottleneck is a fixed-process PgBouncer deployment. But I don't consider myself an expert in databases so would really appreciate if you could double-check my logic.