Re: [BUGS] fillfactor hides autovacuum parameters in 8.4.0 - Mailing list pgsql-hackers

From Itagaki Takahiro
Subject Re: [BUGS] fillfactor hides autovacuum parameters in 8.4.0
Date
Msg-id 20090820101205.998C.52131E4D@oss.ntt.co.jp
Whole thread Raw
Responses Re: [BUGS] fillfactor hides autovacuum parameters in 8.4.0  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
Here is a patch to fix a bug in handling default values in reloptions.
This fix should be applied to HEAD and 8.4.0.

I used 'magic number -1' to propagate "not-specified" information to
autovacuum process. It might look strange because the default value is
out of range of the reloption, but I think it has less impact to the
codes comapred with other solutions (dynamic default values etc.).

> To fix the bug, each field in StdRdOptions should have "not-specified" flag.
> If not specified, autovacuum should use current GUC settings instead of
> reloptions. Is it possible to change the default values of reloptions
> to some magic number (-1 or so) ?

Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center


Attachment

pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: auto_explain log_verbose causes regression failure
Next
From: Robert Haas
Date:
Subject: Re: auto_explain log_verbose causes regression failure