Just out of curiosity, how many rows are touched by the updates on the
master?

One important thing is:

select count(*) from tablea => 1000
update tablea set fieldb=fieldb + 1 => 1 update statement on master,
                                    => BUT 1000 updates on slave

So it's easy to overwhelm a slony system with one statement that
touches many rows.

Andreas
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general

Reply via email to