> -----Ursprüngliche Nachricht----- > Von: Thom Brown [mailto:thombrown@xxxxxxxxx] > Gesendet: Mittwoch, 3. März 2010 16:56 > An: Markus Wollny > Cc: pgsql-general@xxxxxxxxxxxxxx > Betreff: Re: Massive table bloat > If you update rows, it actually creates a new version of it. > The old one doesn't get removed until the VACUUM process > cleans it up, so maybe you need to run that against the database? I already do on a nightly basis (which is probably not often enough in this case) and have got autovacuum running. I'll check into FSM settings as suggested by Grzegorz Jaśkiewicz, there's probably half a solution to the problem there, the other half being probably the autovacuum daemon not visiting this table nearly often enough. Kind regards Markus Computec Media AG Sitz der Gesellschaft und Registergericht: Fürth (HRB 8818) Vorstandsmitglieder: Albrecht Hengstenberg (Vorsitzender) und Rainer Rosenbusch Vorsitzender des Aufsichtsrates: Jürg Marquard Umsatzsteuer-Identifikationsnummer: DE 812 575 276 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
