[Bucardo-general] extremely large bucardo.bucardo_delta table

[Martin Atukunda]

I'm not using makedelta using swap, and there is a sync that is saying WAIT:17h

- Martin -

On 2011-03-04, at 11:32 AM, Michelle Sullivan wrote:

> Martin Atukunda wrote:
>> Hi,
>> 
>> I'm getting some unexpected output. bucardo_purge_delta returns 0 rows deleted, and yet the table definitely has data. Something is wrong.
>> 
>> =>  SELECT bucardo.bucardo_purge_delta('10 minutes'::interval);
>> 
>>                           bucardo_purge_delta
>> -----------------------------------------------------------------------
>>  Rows deleted from bucardo_delta: 0 Rows deleted from bucardo_track: 0
>> (1 row)
>> 
>> =>   SELECT count(*) FROM bucardo.bucardo_delta\g
>>    count
>> -----------
>>  174166527
>> (1 row)
>> 
>> =>  select max (txntime) FROM bucardo.bucardo_delta;
>>               max
>> -------------------------------
>>  2011-03-04 15:26:18.805188+07
>> (1 row)
>> 
>> Time: 6.192 ms
>> =>  select min (txntime) FROM bucardo.bucardo_delta;
>>               min
>> -------------------------------
>>  2010-12-10 15:48:39.186257+07
>> (1 row)
>> 
> 
> 
> Do you have a sync that is currently failed or not running?  Are you 
> using makedelta?
> 
> Michelle
> _______________________________________________
> Bucardo-general mailing list
> Bucardo-general at bucardo.org
> https://mail.endcrypt.com/mailman/listinfo/bucardo-general