On Fri, Jan 17, 2014 at 10:15:20AM -0500, Alex Balashov wrote: > How long is a DELETE of ~4.5 million rows (in a relatively narrow > table) supposed to take in a scenario with a simple pushdelta > replication setup?
That's a lot of rows. Your best bet is to make sure you are logging long queries at the Postgres level (e.g. setting log_min_duration_statment = 500), and then see the exact queries that are taking up most of the time. If you are using the latest Bucardo and going to multiple targets, I just pushed an optimization that should help that case, so git pull and try again :) -- Greg Sabino Mullane [email protected] End Point Corporation PGP Key: 0x14964AC8
signature.asc
Description: Digital signature
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
