> > 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 [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
