Re: fillfactor hides autovacuum parameters in 8.4.0

Itagaki Takahiro wrote:
>
> Alvaro Herrera <alvherre(at)commandprompt(dot)com> wrote:
>
> > > We should remember whether a field was specified or not independntly.
> > I'm not sure what you are suggesting ...?
>
> Please imagine that:
>
> =# SET autovacuum_vacuum_scale_factor = 0.05;
> =# ALTER TABLE tbl SET (autovacuum_vacuum_threshold = 10);

Uh, but this doesn't work because you can't SET inside a session and
have autovacuum read it. Only the values that you change with ALTER
TABLE can be read by autovacuum; the rest of the values come from
postgresql.conf.

But I'm very dizzy today so perhaps I'm missing something obvious.

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