Re: autovacuum

Noah Freire wrote:
> On Wed, Oct 29, 2008 at 4:46 PM, Matthew T. O'Connor <matthew(at)zeut(dot)net
> <mailto:matthew(at)zeut(dot)net>> wrote:
>
>
> Is the table being excluded? (see the pg_autovacuum system table
> settings)
>
>
> there's an entry for this table on pg_autovacuum, and it's enabled.
>
>
> Are you sure that it's not getting processed? Perhaps one worker
> is / has been churning on this table for a *LONG* time (that is a
> fairly big table).
>
>
> Right. I was wrong :-) the table is being processed by autovacuum (I
> checked via pg_stat_activity). However, as you pinpointed, it's
> already running for hours (the test workload ended hours ago,
> basically it is just this autovacuum worker running on the system).
>
> Is there a way to make a more aggressive autovacuum setting for this
> table? it does not matter if it will affect performance, my concern is
> that it finishes as soon as possible. I wonder if a manual vacuum
> wouldn't be faster.

Yes, in the pg_autovacuum table, you can set per-relation vacuum cost
delay settings etc...