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: [email protected] <mailto:[email protected]> > > 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 > [email protected] > http://pgfoundry.org/mailman/listinfo/pgpool-general _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
