[Pgpool-general] pl/pgsql update function is just executed on one backend

[ACHA | Marco Wayop]

>You could add a comment in front of the SELECT query. For example,
>/*REPLICATION*/SELECT your_pl_pgsql_function();

>This will force the SELECT excutes on both nodes.

Nice!
By adding the /*REPLICATION*/ comment to the query the function indeed executes on all nodes.

It is conspicuous that the function is first executed on one node and after finishing on alle other ones.
(derived by CPU load)

Thanks,
Marco