[Bucardo-general] Soemthing weird....
Greg Sabino Mullane
greg at endpoint.com
Thu Jan 16 15:49:56 UTC 2014
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 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/20140116/5ce3ba48/attachment.sig>
More information about the Bucardo-general
mailing list