Re: Still recommending daily vacuum...

From: Michael Paesold <mpaesold(at)gmx(dot)at>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Still recommending daily vacuum...
Date: 2007-07-03 09:31:08
Message-ID: 468A175C.9020901@gmx.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

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.

Best Regards
Michael Paesold

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2007-07-03 09:45:26 Re: Proposal: In-Place upgrade concept
Previous Message Gregory Stark 2007-07-03 09:24:33 Re: what is difference between LOCAL and GLOBAL TEMP TABLES in PostgreSQL

Browse pgsql-patches by date

  From Date Subject
Next Message Jacob Rief 2007-07-03 10:02:35 Re: SPI-header-files safe for C++-compiler
Previous Message Heikki Linnakangas 2007-07-03 08:39:58 Re: Load Distributed Checkpoints, final patch