From: | "Markus Wollny" <Markus(dot)Wollny(at)computec(dot)de> |
---|---|
To: | "Thom Brown" <thombrown(at)gmail(dot)com> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Massive table bloat |
Date: | 2010-03-03 17:57:00 |
Message-ID: | 28011CD60FB1724DBA4442E38277F6260F917AB9@hermes.computec.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> -----Ursprüngliche Nachricht-----
> Von: Thom Brown [mailto:thombrown(at)gmail(dot)com]
> Gesendet: Mittwoch, 3. März 2010 16:56
> An: Markus Wollny
> Cc: pgsql-general(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Joao Ferreira gmail | 2010-03-03 18:02:36 | Re: Auto VACUUM |
Previous Message | akp geek | 2010-03-03 17:46:33 | Auto VACUUM |