> If you want "synchronous replication" because you want "query > availabilty" while making sure you're not getting "stale" queries from > all your slaves, than using your k < N (k = 3 and N - 10) situation is > screwing your self.
Correct. If that is your reason for synch standby, then you should be using k = N configuration. However, some people are willing to sacrifice consistency for durability and availability. We should give them that option (eventually), since among that triad you can never have more than two. -- -- Josh Berkus PostgreSQL Experts Inc. http://www.pgexperts.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers