> -----Ursprüngliche Nachricht-----
> Von: Thom Brown [mailto:thombr...@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 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to