Re: Autovacuum integration patch

From: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
To: Alvaro Herrera <alvherre(at)surnet(dot)cl>
Cc: Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Autovacuum integration patch
Date: 2005-07-05 03:21:46
Message-ID: 42C9FCCA.3060703@zeut.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Alvaro Herrera wrote:

>On Thu, Jun 30, 2005 at 12:03:12AM -0400, Matthew T. O'Connor wrote:
>
>
>>Alvaro Herrera wrote:
>>
>>
>
>Sorry, forgot to mention:
>
>
>
>>>- There are no docs
>>>
>>>
>>I can help here as long as I don't have to have the docs done before July 1.
>>
>>
>
>You don't. Ok, so I'm not writing any docs, I leave that to you :-)
>
>

Ok.

>>>- There are no ALTER TABLE commands to change the pg_autovacuum
>>>attributes for a table. (Enable/disable, set thresholds and scaling
>>>factor)
>>>
>>>
>>I don't think we need this do we? Mucking around in the autovacuum
>>table shouldn't cause the system any serious problems, if you do mess up
>>your values, it's easy to just reset them all to 0 and start back with
>>the defaults.
>>
>>
>
>The problem is you have to be superuser to be able to do it. An ALTER
>TABLE command would allow the table and database owners to do it.
>

Fair point. However I would still put this in the category of nice
additions, but we really don't *NEED* right now.

In response to

Browse pgsql-patches by date

  From Date Subject
Next Message Matthew T. O'Connor 2005-07-05 03:40:09 Re: Autovacuum integration patch
Previous Message Christopher Kings-Lynne 2005-07-05 01:38:30 Re: [HACKERS] Dbsize backend integration