autovacuum suggestions for 500,000,000+ row tables?

From: Alex Stapleton <alexs(at)advfn(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: autovacuum suggestions for 500,000,000+ row tables?
Date: 2005-06-20 14:44:08
Message-ID: BE7E1F60-FA3A-4843-988E-AC2CC1FA22E5@advfn.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi, i'm trying to optimise our autovacuum configuration so that it
vacuums / analyzes some of our larger tables better. It has been set
to the default settings for quite some time. We never delete
anything (well not often, and not much) from the tables, so I am not
so worried about the VACUUM status, but I am wary of XID wraparound
nuking us at some point if we don't sort vacuuming out so we VACUUM
at least once every year ;) However not running ANALYZE for such huge
periods of time is probably impacting the statistics accuracy
somewhat, and I have seen some unusually slow queries at times.
Anyway, does anyone think we might benefit from a more aggressive
autovacuum configuration?

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jacques Caron 2005-06-20 14:59:29 Re: autovacuum suggestions for 500,000,000+ row
Previous Message Jim C. Nasby 2005-06-20 06:53:49 Re: How to determine whether to VACUUM or CLUSTER