Re: Autovacuum on by default?

From: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
To: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Autovacuum on by default?
Date: 2006-08-17 17:40:41
Message-ID: 44E4AA19.2070309@zeut.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Jim C. Nasby wrote:
> On Thu, Aug 17, 2006 at 12:41:57PM -0400, Matthew T. O'Connor wrote:
>
>> Would be fine by me, but I'm curious to see what the community has to
>> say. A few comments:
>>
>> Autovacuum can cause unpredictable performance issues, that is if it
>> vacuums in the middle of a busy day and people don't want that, of
>> course they turn it off easy enough, but they might be surprised.
>>
>
> Anyone in that situation needs to be more hands-on with the database
> anyway. I think the big target for autovac is beginners who otherwise
> would bloat themselves silly (of course, it's also very useful far
> beyond beginners, but by that time an admin should have some clue about
> what they're doing).
>

Fair enough, also if we turn on the delay setting by default, it will
help address this.

> And +1 on Rod's suggestion to make it more aggressive. I always drop the
> scale factor to at least 0.2 and 0.1 (though 0.1 and 0.05 don't seem
> unreasonable), and typically drop the thresholds to 200 and 100 (though
> again, lower is probably warrented).
>

OK.

> Actually, on a table small enough for the thresholds to kick in it's
> going to be extremely fast to vacuum anyway, and the table is probably
> either static or changing very rapidly. I'm wondering if maybe they
> should just default to 0?
>
I assume you are suggesting that the base value be 0? Well for one
thing if the table doesn't have any rows that will result in constant
vacuuming of that table, so it needs to be greater than 0. For a small
table, say 100 rows, there usually isn'tn much performance impact if the
table if 50% dead space, so I think the base values you suggest are OK,
but they shouldn't be 0.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2006-08-17 17:41:03 Re: An Idea for planner hints
Previous Message Alvaro Herrera 2006-08-17 17:38:33 Re: Autovacuum on by default?