[pgpool-general: 4125] Re: LB + streaming replication. Doubling connections to backend

[Tatsuo Ishii]

> Hello all!
> 
> 
> I have a pgpool setup in load balancing + streaming replication modes with
> 4 PostgreSQL nodes.
> 
> 
> Every single connection arriving at pgpool generates 4 conections to the
> backends. Is that correct?

Yes, that's how pgpool-II works.

> I gues that at maximum two connections should be opened (if necessary), one
> to the read-write node, and another to a read-only node.

If you are using streaming replication mode. Yes, that's one of my
personal TODO items.

> In my benchmarks, a workload with 100 concurrent connections to pgpool,
> generates 400 connections to backends (100 connections to each one).

Yes. However that does not affect anything in terms of performance
since pgpool-II does not send any query two of them.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp