Lessons learned scaling a PostgreSQL database to 1.2bn records/month

Re:Lessons learned scaling a PostgreSQL database to 1.2bn re... by gralx on Tuesday January 29, 2019 @07:51AM (#19025876)

In PostgreSQL performance, Google Cloud Platform "beats AWS by a factor of 2 in all [Aiven.io] tests".

[ Parent | on HN ]

Re:Lessons learned scaling a PostgreSQL database to 1.2bn re... by shoo on Tuesday January 29, 2019 @09:10AM (#19026356)

  > A program that produces incorrect results twice as fast is infinitely slower.
    — John Osterhout

[ Parent | on HN ]

Re:Lessons learned scaling a PostgreSQL database to 1.2bn re... by oskari on Tuesday January 29, 2019 @01:16PM (#19028560)

Not sure if this comment was about the data corruption bug in Cloud SQL's PostgreSQL version, but the benchmarks we ran at https://aiven.io/blog/postgresql-cloud-performance/ used Aiven's PostgreSQL service on top of VMs from the cloud infrastructure providers and weren't affected by Cloud SQL issues.

The same Linux, PostgreSQL, etc versions were used on all platforms. We didn't use RDS, CloudSQL or other managed services from the infrastructure providers, but the PDF version of the presentation does include comparison of our managed PostgreSQL service with RDS PG and Aurora PG if you're interested.

[ Parent | on HN ]

Re:Lessons learned scaling a PostgreSQL database to 1.2bn re... by gralx on Tuesday January 29, 2019 @01:54PM (#19028905)

The article doesn't say the GCP results were incorrect. What's your source?

[ Parent | on HN ]

Re:Lessons learned scaling a PostgreSQL database to 1.2bn re... by bmn__ on Wednesday January 30, 2019 @02:43AM (#19033380)

The article said they suffered data corruption. The Osterhout is à propos.

[ Parent | on HN ]

Re:Lessons learned scaling a PostgreSQL database to 1.2bn re... by manigandham on Tuesday January 29, 2019 @04:24PM (#19029920)

Aiven is a managed service vendor and uses cloud VMs. This is not a test of the AWS/GCP directly managed Postgres.

[ Parent | on HN ]