[Bucardo-general] extremely large bucardo.bucardo_delta table

[Michelle Sullivan]

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