[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...
Size: 163 bytes
Desc: Digital signature
More information about the Bucardo-general