6 ms·
I prefer to run PostgreSQL The Grumpy Greybeard Way. Like, on a (virtual) machine. With a config file. I'm doing a web app with terabytes of healthcare data
by claytongulick 3y ago
I prefer to run PostgreSQL The Grumpy Greybeard Way.
Like, on a (virtual) machine.
With a config file.
I'm doing a web app with terabytes of healthcare data with intense computation and geospatial queries with an average 60ms response time including latency.
On a modest vm.
With a config file.
- ibash 3y agoWith a WHAT?
- claytongulick 3y agoA config file. :-)
- samokhvalov 3y agoYou'll probably like this: https://github.com/vitabaks/postgresql_cluster https://github.com/vitabaks/postgresql_cluster
- claytongulick 3y agoI do like it! My current DR/HA is basically just hourly block level delta snapshots. It's super simple, cheap and easy to do if the business can tolerate up to an hour of potential data loss.
- yjftsjthsd-h 3y agoRunning a database on a VM doesn't sound very Greybeard™ of you; don't you know that abstracting like that kills performance and takes you away from the hardware? (Only half joking; obviously you totally can make it run fine on a VM, but it also runs fine in a container.)