[Pgpool-general] Replication working but sending unnecessary reset_query_list

[Tatsuo Ishii]

Great idea. I have never thought about that.
Let me look into this.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> Hi,
> 
> We have pgpool-II 2.3.1 running successfully between 2 servers.
> 
> Data is being updated at both ends as expected.
> 
> We have replicate_select set to false (the default), so select 
> statements are only going to the local server.
> 
> We have 99% select versus 1% other statements and are relying on not 
> replicating the select statements to keep performance close to the pre 
> pgpool-II level.
> 
> The problem I am seeing is that the reset_query_list is being sent to 
> both servers even when one of them has received no statements.
> 
> As a consequence selects which are local still reach out and send abort 
> statements to the remote server. This results in a significant reduction 
> in performance.
> 
> Is there any way to stop the reset statements being sent to a server 
> which hasn't been sent any statements? If I have waded through the code 
> a bit and it doesn't seem that there is a way of doing this.
> 
> Cheers
> 
> -- 
> Simon L Jackson
> Corpita Pty Ltd
> 
> +-
> Corpita Pty Ltd
> 
> Web: www.corpita.net <http://www.corpita.net/>
> Email: simon.jackson at corpita.net <mailto:simon.jackson at corpita.net>
> 
> Office: +61 3 9411 4470
> Fax: +61 3 9411 4499
> 
> Level 1
> 15 Bedford Street
> Collingwood VIC 3066
> Australia
> 
> P.O. Box 1464
> Collingwood VIC 3066
> Australia
> +-
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general