[Bucardo-general] Soemthing weird....

Greg Sabino Mullane greg at endpoint.com
Thu Jan 16 18:45:15 UTC 2014

> > 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.
> >
> >   
> Recommendations, up or down?

Up. Too high and you hit an internal Postgres limit, however. Maybe 
try doubling it to start with. It probably will not make much of a 
difference, to be honest, so I wouldn't burn a lot of time on it.

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/2a6f61f7/attachment.sig>

More information about the Bucardo-general mailing list