Re: [HACKERS] Autovacuum loose ends

From: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
To: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-patches(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Autovacuum loose ends
Date: 2005-07-26 15:45:19
Message-ID: 42E65A8F.70705@zeut.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Alvaro Herrera wrote:

>Two comments still apply:
>
>- I haven't done anything yet w.r.t. the custom vacuum_delay nor sleep
> scale factor.
>

I don't think we need the sleep scaling factor. Before we had vacuum
delay settings, it might have been useful as a means of throttling down
the impact of autovacuum, but I think the delay settings are the better
way to go.

As for the custom vacuum_delay settings, Tom Lane's commented that it
probably wasn't needed. However I and several others responded saying
that it probably would be useful for certain use cases. I'm still not
sure how compelling that case is but it seems like a simple addition.
Perhaps this is something we can add for 8.2 if people seem to want it.

>- There are still no docs.
>

I'm on the hook for this and will start working on them next week.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-07-26 16:44:57 Re: [PATCHES] Roles - SET ROLE Updated
Previous Message Tom Lane 2005-07-26 14:39:14 Re: Rollback issue with SET ROLE

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2005-07-26 16:44:57 Re: [PATCHES] Roles - SET ROLE Updated
Previous Message Neil Conway 2005-07-26 06:00:24 Re: User's exception plpgsql