On Thu, Jan 16, 2014 at 02:17:49PM +0100, Michelle Sullivan wrote: ... > Unique (cost=0.00..127077133.70 rows=1 width=16) (actual > time=0.127..151490.022 rows=28464412 loops=1)
28,464,412 28 million(!) rows is why things are so slow. If it is the delete portion that is slow, you can try adjusting the statement_chunk_size. It may be easier to find the large DELETE in your logs and just re-run that at different sizes. -- 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
