Hi,I have a scenario   where I want to use Slony for master-slave replication 
and pgpool for load-balancing and where I have many functions with write 
commands. When using these functions I issue a command like "select * from 
somefunction(1, 'xpto')" and 'somefunction' will do several queries, being one 
of them an insert/update. How will pgpool load-balance this kind of queries? Is 
it able to see that it's not a read-only command and will send the command 
always only to the master? More generically, how did pgpool deal with functions 
and triggers?Thanks,Nelson  
_________________________________________________________________
News, entertainment and everything you care about at Live.com. Get it now!
http://www.live.com/getstarted.aspx
_______________________________________________
Pgpool-general mailing list
[email protected]
http://pgfoundry.org/mailman/listinfo/pgpool-general

Reply via email to