Re: fillfactor hides autovacuum parameters in 8.4.0

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Itagaki Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
Cc: pgsql-hackers(at)postgresql(dot)org, pgsql-bugs(at)postgresql(dot)org
Subject: Re: fillfactor hides autovacuum parameters in 8.4.0
Date: 2009-08-27 15:43:36
Message-ID: 20090827154336.GG11213@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

Itagaki Takahiro wrote:
>
> 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.).

I realized that any other solution here is going to be more complex and
thus less appropriate for backpatch. I still don't like this very much
because it doesn't seem to offer enough flexibility to user-specified
reloptions; but any patch we come up with here is going to be applicable
to CVS HEAD.

So I'm going to apply your patch to both 8.4 and HEAD; we can always
improve it later, I guess.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Magnus Hagander 2009-08-27 15:45:41 Re: BUG #5008: Server Startup Problem - When server is configured for SSL
Previous Message Magnus Hagander 2009-08-27 15:35:19 Re: BUG #4996: postgres.exe memory consumption keeps going up

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2009-08-27 15:46:46 Re: BUG #4996: postgres.exe memory consumption keeps going up
Previous Message Greg Stark 2009-08-27 15:38:13 Re: 8.5 release timetable, again