Greg Sabino Mullane wrote: > 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. > > Recommendations, up or down?
-- Michelle Sullivan http://www.mhix.org/ _______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
