| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Stuart Brooks <stuartb(at)cat(dot)co(dot)za> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: autovacuum not freeing up unused space on 8.3.0 |
| Date: | 2008-02-26 12:15:39 |
| Message-ID: | 20080226121539.GA5763@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Stuart Brooks wrote:
> I am not using an ALTER table command but I am doing periodic ANALYZEs
> to evaluate the table size. Could this be causing the problem? I notice
> that stopping the ANALYZE calls appears to eliminate the canceled
> autovacuum.
Why were you running ANALYZE on the first place? If it's just to see
how many dead space there is, I suggest you peek into
pg_stat_user_tables instead, which is less invasive. Autovacuum itself
should run ANALYZEs as needed (and you can, of course, tune it if you
feel it's not frequent enough in the default configuration).
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | justin tocci | 2008-02-26 14:05:37 | Re: APEX / HTML DB for PostgreSQL |
| Previous Message | Stuart Brooks | 2008-02-26 12:15:07 | Re: autovacuum not freeing up unused space on 8.3.0 |