[Pgpool-general] About load balancing and "SELECT FOR UPDATE"

[Tatsuo Ishii]

> Which is the behaviour of pgpool if load balancing is enabled, and it
> receives a "SELECT FOR UPDATE" query?. Does it block the related records in
> BOTH databases?

Yes.

I assume you use SELECT FOR UPDATE in a transaction block (otherwise
it'll be pretty useless). Since pgpool never loadbalance any SQL
command in a transaction block, SELECT FOR UPDATE will be replicated
to each server.
--
Tatsuo Ishii