Re: fillfactor hides autovacuum parameters in 8.4.0 - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: fillfactor hides autovacuum parameters in 8.4.0
Date
Msg-id 20090819203221.GJ4894@alvh.no-ip.org
Whole thread Raw
In response to fillfactor hides autovacuum parameters in 8.4.0  (Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
Responses Re: fillfactor hides autovacuum parameters in 8.4.0  (Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
List pgsql-bugs
Itagaki Takahiro wrote:

> 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) ?

Ah.  After checking the code I remember that this was right at some
point, but it was lost when the parsing step was made to use a table
(fillRelOptions).  This behavior could be restored by having the fill
routine have a callback of some sort; we could use that to set a boolean
in StdRdOptions that indicated whether they are set in reloptions or are
default values.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-bugs by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: BUG #4961: pg_standby.exe crashes with no args
Next
From: Itagaki Takahiro
Date:
Subject: Re: fillfactor hides autovacuum parameters in 8.4.0