On 7/5/2007 9:33 AM, Csaba Nagy wrote:
On Thu, 2007-07-05 at 10:13, Csaba Nagy wrote:
[snip] Then delete
the unneeded data on both DBs. [snip]
OK, I should have said that the deletion is done in reasonably sized
chunks so that each deletion transaction doesn't take ages. Maybe this
is why slony was up to the task, even if the delete statement ratio from
master to slave would be between 1...10K.
So then no, I don't have a scenario where I would delete millions of
rows in one statement and slony would have to replicate that to millions
of single statements... that would kill the master too...
You could do THOSE mass deletes via EXECUTE SCRIPT ;-)
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== [EMAIL PROTECTED] #
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
