Re: Massive table bloat

> -----Ursprüngliche Nachricht-----
> Von: Thom Brown [mailto:thombrown@gmail.com]
> Gesendet: Mittwoch, 3. März 2010 16:56
> An: Markus Wollny
> Cc: pgsql-general@postgresql.org
> Betreff: Re: [GENERAL] 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
checkinto FSM settings as suggested by Grzegorz Jaśkiewicz, there's probably half a solution to the problem there, the
otherhalf 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