3 ms·
> I regularly kickstart systems You should absolutely start with a minimal stack and Postgres is a good choice for that. Everyone likes to pretend that scaling
by exabrial 4y ago
> I regularly kickstart systems
You should absolutely start with a minimal stack and Postgres is a good choice for that. Everyone likes to pretend that scaling is their problem because it's a sexy problem to have... but really their problem is that the product doesn't exist.
Postgres cannot hold a candle to Oracle or even DB2 when it comes to scale. I've worked at two places did real-time transaction processing on gigunda IBM mainframes. One was Oracle and the other was DB2... This was 15 years ago and the databases were terabytes in size back then... all queryable in milliseconds. Backups, restoration, and schema changes while the system is running is not an issue... And these systems simply did not go down, ever.
- kubota 4y agoFWIW there are several horizontally scaleable relational databases out there (Cockroach, Yugabyte) compatible with pg wire protocol. So you can mostly keep your application queries / driver the same and move to a horizontal solution easier than if you were on Oracle. I don't think Oracle has a horizontally scaling solution. Might be wrong though.