[Bucardo-general] Latency on delete
Greg Sabino Mullane
greg at endpoint.com
Fri Jan 17 16:09:27 UTC 2014
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 greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 163 bytes
Desc: Digital signature
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20140117/87010bfa/attachment.sig>
More information about the Bucardo-general
mailing list