Is this /* NO LOADBALANCE */ documented anywhere? Wondering if I am missing some documentation on pgpool-II.
thanks, bruce On May 31, 2008, at 6:07 PM, Paul Robert Marino wrote: > Think of pgpool as a smart proxy. While it can uderstand that an > insert > update or replace is a write function that must go only to a master > node > it has no real understanding of any rules functions or trigers in your > database. So it has no way of figuring out that your query is any > different then a standard select without you telling it. > On Fri, 30 May 2008 2:47 am, Yoshiyuki Asaba wrote: >> Hi, >> >> From: Nelson Correia <[EMAIL PROTECTED]> >> Subject: [Pgpool-general] Load balancing read-write functions >> Date: Thu, 29 May 2008 10:00:54 +0000 >> >>> 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 >> >> If you would like to send a SELECT query to a master node, >> add "/* NO LOADBALANCE */" at the beginning of the query. >> >> SELECT * from somefunction(1, 'xpto'); >> >> --> >> >> /* NO LOADBALANCE */ SELECT * from somefunction(1, 'xpto'); >> >> Regard, >> -- >> Yoshiyuki Asaba >> [EMAIL PROTECTED] >> _______________________________________________ >> Pgpool-general mailing list >> [email protected] >> http://pgfoundry.org/mailman/listinfo/pgpool-general > ___________________________________________ > The average person does a lot of work in the name of laziness! > Save youre self the effort by doing it right the first time. > Do it with free speech software. > _______________________________________________ > 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
