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

[kiet.h.lieng]

> 
> 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?