[Bucardo-general] Disk Space Usage Looking for help

[Michael Rasumoff]

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

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20120511/bd9d1c66/attachment.html>