[Bucardo-general] Disk Space Usage Looking for help

[Itamar Reis Peixoto]

On Fri, May 11, 2012 at 6:02 PM, Michael Rasumoff
<michael.rasumoff at mvisolutions.com> wrote:
> Hello, I had a contractor install Bucardo for one of my clients.
>
>
>
> The client is now reporting his disk space for his database partition is
> being used  up at an extremely fast rate and wants to know if we’ve
> configured something wrong.
>
>
>
> I'm not an expert on PostgreSQL, but if I'm interpreting this information
> correctly the Bucardo tables are taking up 3x as much space as the rest of
> the database:
>
>
>
> gamemine=# select sum(relpages) from pg_class where relname like
> 'bucardo_%';
>
>    sum
>
> ---------
>
> 3398023
>
> (1 row)
>
>
>
> gamemine=# select sum(relpages) from pg_class where relname not like
> 'bucardo_%' and relname not like 'pg_toast_%';
>
>    sum
>
> ---------
>
> 1195956
>
> (1 row)
>
>
>
> That's a lot of deltas for tables that aren't supposed to be that active.
>
>
>
> Can anyone tell me the steps to troubleshoot this issue or if anyone is
> available to be hired as a consultant and can take a look at our
> configuration?
>
>
>
> Please advise we are desperate for some answers.
>
>
> Thank you.
>
>
>
> Michael
>
>
>

have you setup the cronjob to cleanup ?



-- 
------------

Itamar Reis Peixoto
msn, google talk: itamar at ispbrasil.com.br
+55 11 4063 5033 (FIXO SP)
+55 34 9158 9329 (TIM)
+55 34 8806 3989 (OI)
+55 34 3221 8599 (FIXO MG)