Waldo Nell pwnell at telkomsa.net
Fri Jul 9 13:25:04 PDT 2010
I need to run an update statement pretty much like:

 update XXX set Y = 'Y' where Z = 1;

but table XXX contains approximately 130 million rows.  This will translate to 130 million update statements via Slony-I to the other replicated node.  Any more efficient way to update this?  If not, will Slony-I break on this update?

Thanks


More information about the Slony1-general mailing list