Dear Andreas We have around 15-20 big table tables, each has around more than 2000 rows in that tables.We need to set any parameter in postgresql.conf file or Parameter needs to set for the slony.
Best regards, g.Muniswamy -----Original Message----- From: Andreas Kostyrka [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 27, 2007 3:38 PM To: G Muniswamy Cc: [email protected] Subject: Re: [Slony1-general] Slave system becomes Slow 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 -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean. -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean. _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
