[Pgpool-general] selects in replication mode

[Tatsuo Ishii]

> Pgpoolers,
> 
> can someone please educate me on this matter.  I am trying to get pgpool 
> to work in replication mode for my application.  Why are selects 
> replicated to both backends ?  This causes an issue as pgpool terminates 
> the connection should the selects return slightly different result sets, 
> and unless I turn on strict mode (which kills performance) these selects 
> very well may return different results given that different transactions 
> have finished committing to the backends at any given time.
> 
> I would think that select statements would never be sent to multiple 
> backends, especially under replication mode when both hosts are up.

Doing that would break some SELECTs which have side effects, such as
SELECT nextval(), no?
--
Tatsuo Ishii
SRA OSS, Inc. Japan

> Thanks in advance for any wisdom you can offer.
> 
> alex
> 
> -- 
> 
> Alex Orloff
> Software Engineering
> Root Exchange, a division of Root Markets
> http://www.rootexchange.com
> W  (510) 812-3163
> F  (415) 643-6789
> E - aorloff at rootexchange.com 
> 
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general