Itagaki Takahiro wrote: > > Alvaro Herrera <alvhe...@commandprompt.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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs