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

[Jaume Sabater]

On Sun, Dec 13, 2009 at 11:44 PM, Jaime Casanova
<jcasanov at systemguards.com.ec> wrote:

> create or replace function f1() returns integer as $$
>    insert into t1 values(current_date);
>    select 1;
> $$ language sql volatile;
>
> the insert executed as a side effect in the function f1() could be
> sent to an slave instead of the master, something we can make to solve
> this?

Correct. pgpool-II has its limitations, as stated in the docs. Still,
pgpool-II has methods to capture instructions such as the insert above
and make sure the returned value in the master is propagated to the
slave nodes.

Not sure what it does when the insert is inside a function, though.

-- 
Jaume Sabater
http://linuxsilo.net/

"Ubi sapientas ibi libertas"