Our Journey to PostgreSQL 12

Re:Our Journey to PostgreSQL 12 by derekperkins on Monday January 25, 2021 @09:05PM (#25911587)

5TB is not that large and it's not that difficult to get good performance. We operated a 50TB single instance of MySQL for 5 years with a tiny team before migrating to Vitess, and it was basically zero maintenance. We did partition our largest table, which just requires a little extra SQL, but is otherwise transparent.

[ Parent | on HN ]

Re:Our Journey to PostgreSQL 12 by throwdbaaway on Tuesday January 26, 2021 @12:01AM (#25912751)

You guys are talking past each other, as your workloads appear to be different. With a traditional RDBMS, size usually wouldn't be a bottleneck, as long as you can add enough disks to a single server.

Write operations per second, that's the metric I would care about. A 50TB instance with low amount of write operations can be zero maintenance, while a 500GB instance with high amount of write operations can be a real pain.

[ Parent | on HN ]

Re:Our Journey to PostgreSQL 12 by lopatin on Tuesday January 26, 2021 @02:25AM (#25913399)

Thank you for validating my troubles with a write-heavy ~500GB db in the midst of a TB-measuring contest :)

[ Parent | on HN ]