[Bucardo-general] Soemthing weird....

[Michelle Sullivan]

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/