3 ms·
nit: Postgres doesn't scale horizontally, it only scales vertically.
by tlarkworthy 11y ago
nit: Postgres doesn't scale horizontally, it only scales vertically.
- andrewflnr 11y agoI guess if you're putting more servers in a rack, it does tend to be a vertically-oriented process. :)
- manigandham 11y agoIt doesnt scale vertically either. Postgres is single-threaded meaning it can't make use of multiple CPU cores on the same machine. There have been some slow improvements to this and 9.6 seems to hint at some parallel aggregation changes but overall Postgres is strong in features but weak in scaling (in any direction).
- anarazel 11y ago"hint at"?
- manigandham 11y agohttps://news.ycombinator.com/item?id=11331602 https://news.ycombinator.com/item?id=11331602 It looks good, will have to wait and see what actually makes it into 9.6 and how well it supports all the possible queries. This is something that many commercial databases have solved so Postgres is pretty behind in vertical scaling.
- anarazel 11y agoTo me it's a bit weird calling committed patches "hints".
- tlarkworthy 11y agoBritish English vs. American English? I dunno if the poster is British but I am. I read that they haven't done enough to call pg vertically scalable but recent work suggestions (hints) that they are working toward it. The expression is more metaphorical than literal, an Atlantic divide my American colleagues explicitly warn me about when I am writing my perf reviews.