On Tue, Dec 11, 2012 at 1:09 PM, Sergey Konoplev <[email protected]> wrote: > On Tue, Dec 11, 2012 at 8:11 AM, Michael Sawyers <[email protected]> wrote: >> We have a table currently using 33gb worth of space for only 152mb worth of >> data because of bad processes or autovacuum not being aggressive enough. I >> was able to confirm the size difference by doing a create table as select >> along with a second test of restoring the table from the dump file to a dev >> machine. > > You can use pgcompactor (http://code.google.com/p/pgtoolkit/) to > gently reduce bloat. It does not use heavy locks, processes both > tables and indexes, determines if one is bloated and tested on 8.4.
Sorry, forget to mention. It does not need an extra space and does not required a service window. -- Sergey Konoplev Database and Software Architect http://www.linkedin.com/in/grayhemp Phones: USA +1 415 867 9984 Russia, Moscow +7 901 903 0499 Russia, Krasnodar +7 988 888 1979 Skype: gray-hemp Jabber: [email protected] -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
