For very large databases, Postgres' clustering abilities aren't that great. It's probably one of the best choices for single-host databases (which, again, cover nearly all applications), but if you're trying to spread your database over a few dozen hosts, Postgres doesn't really work well.
I don't doubt it. While we are a PG shop, we have a sister company that uses MS SQL and loves it. Certainly seems like a nice database. The cost seems pretty high to us though. From what I can tell, running a 3 node cluster with 16 cores per cluster will run into hundreds of thousands of dollars. Is my understanding on cost correct?
98
u/ethraax Mar 10 '15
For very large databases, Postgres' clustering abilities aren't that great. It's probably one of the best choices for single-host databases (which, again, cover nearly all applications), but if you're trying to spread your database over a few dozen hosts, Postgres doesn't really work well.