[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