[pgpool-general: 4321] Re: How to test pgpool?

kiet.h.lieng kiet.h.lieng at gmail.com
Wed Jan 13 16:34:50 JST 2016

> Pgpool has a built in SQL parser inside. By using it, pgpool can know
> whether it gets update the database. If so, pgpool will route the
> query to the master (primary) PostgreSQL. If the query does not update
> the database, pgpool sends it to either the master or one of the
> standbys depending on the setting of configurations related to load
> balancing.
> You could know which database server pgpool routes queries by using
> log_per_node_statement.

Is it not true that transactions are atomic?  If that is true then how can multiple queries be dissected as such?  It’s not really atomic if you can decide which transaction queries go where?

More information about the pgpool-general mailing list