| From: | "Jim C(dot) Nasby" <decibel(at)decibel(dot)org> |
|---|---|
| To: | Michael Paesold <mpaesold(at)gmx(dot)at> |
| Cc: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Still recommending daily vacuum... |
| Date: | 2007-07-03 20:09:41 |
| Message-ID: | 20070703200941.GU85497@nasby.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
On Tue, Jul 03, 2007 at 11:31:08AM +0200, Michael Paesold wrote:
> Joshua D. Drake wrote:
> >Alvaro Herrera wrote:
> >>Joshua D. Drake wrote:
> >>>Did we change the default autovac parameters for 8.3 (beyond turning
> >>>it on?) because on any reasonably used database, they are way to
> >>>conservative.
> >>
> >>We're still on time to change them ... Any concrete proposals?
> >
> >I could provide numbers from production high use databases. We could
> >probably back those down a little and make more reasonable numbers.
>
> Please do so. Perhaps others can also tell their typical settings.
FWIW, I normally go with the 8.2 defaults, though I could see dropping
vacuum_scale_factor down to 0.1 or 0.15. I also think the thresholds
could be decreased further, maybe divide by 10.
--
Jim Nasby decibel(at)decibel(dot)org
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim C. Nasby | 2007-07-03 20:13:40 | Re: Still recommending daily vacuum... |
| Previous Message | Greg Smith | 2007-07-03 19:42:25 | Re: ACM Paper relevant to our buffer algorithm |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim C. Nasby | 2007-07-03 20:13:40 | Re: Still recommending daily vacuum... |
| Previous Message | Tom Lane | 2007-07-03 16:43:58 | Re: pgstat_drop_relation bugfix |