Brad Nicholson bnichols
Fri Jan 19 05:55:46 PST 2007
You should raise your questions with the folks on the pgpool list.
Slony people probably aren't the right audience to discuss pgpool mods
with.  A couple quick points though - 


On Thu, 2007-01-18 at 18:20 -0800, Christian Storm wrote:
> Right now, if I understand it right, pgpool will 'stick' SELECT  
> statements to the master if they are in a transaction block.   

Correct.

> Otherwise, they go
> to the slave.  As I'm sure you know, this can cause problems when  
> SELECT queries are run against the slave and the data hasn't arrived yet
> due to the replication lag.

That problem doesn't exist if you put your queries inside a transaction.
They will never go to a subscriber.  

-- 
Brad Nicholson  416-673-4106
Database Administrator, Afilias Canada Corp.




More information about the Slony1-general mailing list