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.                                  #
#================================================== JanWieck at Yahoo.com #