[Pgpool-general] [pgpool-general] load balancing for dummies

[Marcos Davi Reis]

Jaime,
I have the same problem, and I'm using /*REPLICATION*/ hint to execute
the procedure in all nodes and keep the sync between them. its working
fine for me.
Is it wrong? is there another better solution?

Att,
Marcos Davi Reis
Mova
www.movaomundo.com



On Mon, Dec 14, 2009 at 11:08 AM, Jaime Casanova
<jcasanov at systemguards.com.ec> wrote:
> On Mon, Dec 14, 2009 at 2:42 AM, Guillaume Lelarge
> <guillaume at lelarge.info> wrote:
>>
>> This is because pgpool only see the call to the function and has no way to
>> know what the function could do. So, when you're using pgpool in load
>> balancing mode, don't use functions that modify the database.
>>
>
> yeah! my example was overly complex, just doing "select
> some_volatile_function();" will be a problem...
> so if i have an application that i want to load balance i have to
> check it all to be sure it's compatible with pgpool?
>
> what if we simply add a new condition to load balancing, the SELECT
> statement has no volatile functions in it and make pgpool not trying
> to load balancing such SELECTs
>
> --
> Atentamente,
> Jaime Casanova
> Soporte y capacitación de PostgreSQL
> Asesoría y desarrollo de sistemas
> Guayaquil - Ecuador
> Cel. +59387171157
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general
>



-- 
Marcos Davi Reis
Mova
www.movaomundo.com
+55 21 3553-1511
+55 21 9923-8319