| From: | "Jim C(dot) Nasby" <jim(at)nasby(dot)net> |
|---|---|
| To: | Medora Schauer <mschauer(at)fairfield(dot)com> |
| Cc: | Bill Moran <wmoran(at)collaborativefusion(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: autovacuum not working? |
| Date: | 2006-10-09 21:26:15 |
| Message-ID: | 20061009212615.GN72517@nasby.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Mon, Oct 09, 2006 at 09:27:30AM -0500, Medora Schauer wrote:
> > From your attached config file:
> >
> > #autovacuum_vacuum_threshold = 1000 # min # of tuple updates before
> > # vacuum
> >
>
> Yup, that was it.
Actually, not quite.
Vacuum will update relpages and reltuples, but it won't update other
stats. That's what analyze does (autovacuum_analyze_threshold). By
default, that's set to 500; I'll typically drop it to 200 or so (keep in
mind that analyze is much cheaper than vacuum).
--
Jim Nasby jim(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tobias Brox | 2006-10-09 21:33:03 | Re: Simple join optimized badly? |
| Previous Message | Jim C. Nasby | 2006-10-09 21:23:56 | Re: odd variances in count(*) times |