Re:Vertically Scaling PostgreSQL
by 11235813213455 on Tuesday March 19, 2019 @06:07PM
(#19436558)
just wondering, did you have to plan a maintenance downtime for doing all that or could it be done without interrupting the production DB?
[ Parent
| on HN ]
Re:Vertically Scaling PostgreSQL
by beatgammit on Tuesday March 19, 2019 @09:20PM
(#19437976)
Not OP, but I imagine you could just duplicate the DB into a test environment to mess around with it.
That's exactly what it was. I had a bit of time after buying the server before I wanted to deploy it in production so I copied the last backup over and just started messing around. Because this database primarily ingests data from outside sources and doesn't drive user experiences, I was able to easily duplicate the data flow to replicate the production environment.
I recognize this would be a much different beast when it comes to a database that supports a hundred thousand users or something. However, Postgresql does have the ability to do hot standby and streaming replication so it's likely not as difficult as one might imagine.