[Bucardo-general] extremely large bucardo.bucardo_delta table

[Martin Atukunda]

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)


On 2011-03-04, at 10:35 AM, Michelle Sullivan wrote:

> Martin Atukunda wrote:
>> Thanks Michelle,
>> 
>> I'll add that cron job and see if it removes the old data.
> 
> Tip: run it once first then add the cronjob or you'll get lots of them running..! ;-)
> 
> Shells
> 
>> 
>> - Martin -
>> 
>> On 2011-03-04, at 9:45 AM, Michelle Sullivan wrote:
>> 
>>> Martin Atukunda wrote:
>>>> Hi,
>>>> 
>>>> I have a setup here with two master databases. the main database has a bucardo.bucardo_delta table that has 174,377,043 rows in it.
>>>> 
>>>> This table is vacuumed regularly, and is still quite large.
>>>> 
>>>> last txntime is: 2011-03-04 12:33:51.697631+078:41
>>>> earliest is: 2010-12-10 15:48:39.186257+07
>>>> 
>>>> I rebuilt the replication system on 2011-01-15.
>>>> 
>>>> Is it safe for me to remove the older rows from the bucardo.bucardo_delta table?
>>>> 
>>> 
>>> 
>>> You didn't set up the cronjob to remove them then?
>>> 
>>> This is what you need on all servers:
>>> 
>>> */15 * * * * /usr/local/bin/psql -X -q -d replicateddatabase -U pgsql -c
>>> "SELECT bucardo.bucardo_purge_delta('10 minutes'::interval)"
>>> 
>>> 
>>> Michelle
>>> 
>> 
>