[Pgpool-general] Number of PostgreSQL server manage with pgpool-II!!!

[Josh Berkus]

On 2/21/11 6:24 PM, Lazaro Ruben Garcia Martinez wrote:
> The number of server that can take place in the cluster, all of then
> replicated with pgpool-II without lost performance?

That's not really a meaningful question.

pgPool2 replication is statement-based replication.  If you have even a
second server, you're going to pay 5-20% overhead on writes, depending
on workload.  With more servers, the penalty on writes goes up.

The general idea of pgPool2 replication is that some workloads are 90%
reads, so the benefit from load-balancing the reads can outweigh the
penalty from replicating the writes.

So what % reads is your workload?

-- 
                                  -- Josh Berkus
                                     PostgreSQL Experts Inc.
                                     http://www.pgexperts.com