Fri Jan 19 05:55:46 PST 2007
- Previous message: [Slony1-general] slony replication lag and pgpool
- Next message: [Slony1-general] slony replication lag and pgpool
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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.
- Previous message: [Slony1-general] slony replication lag and pgpool
- Next message: [Slony1-general] slony replication lag and pgpool
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list