Search Postgresql Archives

Re: Autovacuum Improvements

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



>-----Original Message-----
>From: pgsql-general-owner@xxxxxxxxxxxxxx 
>[mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of 
>Matthew O'Connor
>Sent: woensdag 20 december 2006 2:53
>To: Glen Parker; Postgres General
>Subject: Re: [GENERAL] Autovacuum Improvements
>
>Alvaro Herrera wrote:
[snip]
>I would go one step further and suggest that when the 
>maintenance window system gets completed we give it a default 
>setup of midnight to 6AM or something like that.
>

Do not do that...
For this reason:
* Any serious database administrator will read the documentation and
take the time to configure the system for such a setup. The setup will
be specific to his/her demands, competing with the backup window
perhaps.
* Any new user, developers and hobbiests don't need such things to
increase performance a little and several most likely turn off their
systems during the night. This effectively results in people that get
serious problems using postgresql, because vacuum never runs. You know
who they will blame for it.

Just my opinion...

- Joris


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux