2 ms·
I cannot comment on its horizontal scaling. I can say however that Postgres, from what I understand, has nearly linear SMP vertical scaling up to 64 cores. The
by hoodoof 11y ago
I cannot comment on its horizontal scaling.
I can say however that Postgres, from what I understand, has nearly linear SMP vertical scaling up to 64 cores. There's an awful lot of headroom there. I read a long while back Jeff
Atwood saying that StackOverflow ran on a single vertically scaled database server with MSSQL for a long time.
If I needed to go beyond vertical then I'd maybe horizontally scale in a custom manner based around the application data access characteristics, which plays a huge role in designing sensible horizontal scaling solutions.
- namelezz 11y agoThank you for your response. I was asking the questions because when I was evaluating MySQL and PostgreSQL 3 years ago I ended up choosing MySQL due to its community and the rumor about difficulties in horizontal scaling of PostgreSQL even though I really liked PostgreSQL JSON support. I hear PostgreSQL is getting better at scaling horizontally although I do not know how good it is now.
- hoodoof 11y agoHorizontal scaling comes with a who range of tradeoffs that you need to make and exactly how you horizontally scale I think has alot to do with how your application stores, reads and writes data.