Re: pg_autovacuum vacuum cost variables patch - Mailing list pgsql-patches

From Matthew T. O'Connor
Subject Re: pg_autovacuum vacuum cost variables patch
Date
Msg-id 417E5373.4060907@zeut.net
Whole thread Raw
In response to Re: pg_autovacuum vacuum cost variables patch  ("Michael Paesold" <mpaesold@gmx.at>)
List pgsql-patches
Michael Paesold wrote:

> Matthew T. O'Connor wrote:
>
>> Two questions:
>> 1) It is my understanding that these new GUC vars only effect vacuum.
>> That is they do NOT have any effect on an analyze command right? (I ask
>> since I'm only setting the vars before I issue a vacuum command)
>
>
> No, vacuum also affects analyze alone (cvs tip here):
> (2.5 seconds -> 50 seconds)
>
> [snip examples...]

> I suggest you also issue the SET commands for analyze also. ISTM that
> there is also no distinction between VACUUM and VACUUM FULL, but I
> think pg_autovacuum never does a vacuum full, so there is no problem
> with that.


Ok, I'll do that too.

pgsql-patches by date:

Previous
From: "Matthew T. O'Connor"
Date:
Subject: Re: pg_autovacuum vacuum cost variables patch
Next
From: Tom Lane
Date:
Subject: Re: pg_autovacuum vacuum cost variables patch