[Bucardo-general] extremely large bucardo.bucardo_delta table

[Michelle Sullivan]

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
>>
>