Our postgres server is about hitting its capacity and we're looking into adding a second database server. Are there any scaling solutions that are particularly good for a postgres setup?
+5
A:
You are looking at a limited set of choices, very dependent on what your specific requirements are (read-to-write ratios and how tolerant your application is of occasional inconsistent reads [synchronous vs. asynchronous replication? master-slave vs. multi-master?], how strongly connected your tables are [clustering], etc.)
vladr
2009-02-20 20:40:59
No need for me to write an answer now... you said it perfectly.
womble
2009-02-20 22:41:23
+2
A:
Did you check what is your bottleneck? What are the queries that make your server work hard? Maybe it can be tuned better.
If tuning will not help it is often much easier to upgrade a server than to set replication. Adding some disks in RAID1 or RAID10, adding some RAM, more cores and faster processor. A good RAID controller with battery backed cache would make a big difference too.
Replication id good for high availability but often a bigger server will be more cost effective if you have performance problems.
Tometzky
2009-02-25 08:59:48
A:
There's Postgres Advanced Server, and Continuent Tungsten are also worth looking into for an enterprise class solution.
Mr Shoubs
2010-04-19 14:49:02