[pgpool-general: 269] Re: loadbalanceing of pg_stat* queries

Toshihiro Kitagawa kitagawa at sraoss.co.jp
Thu Mar 8 22:38:04 JST 2012


On Thu, 8 Mar 2012 11:44:19 +0100
Jens Wilke <jens.wilke at affinitas.de> wrote:

> Hi,
> 
> are queries on pg_stat tables* loadbalanced or are they always send to node 0?

I looked into pgpool-II 3.0.6 and 3.1.2.

In master/slave mode, queries on system catalogs are always send to
primary node or master node.

In replication mode, queries on system catalogs are loadbalanced.

-- 
Toshihiro Kitagawa
SRA OSS, Inc. Japan



More information about the pgpool-general mailing list