Jerry Sievers <[EMAIL PROTECTED]> writes:
> Uncommenting the settings in postgresql.conf and  giving the new
> values, then followed by a pg_reload_conf() call however and I see no
> change in the settings. 

Works for me ...

regression=# show autovacuum_vacuum_scale_factor;
 autovacuum_vacuum_scale_factor
--------------------------------
 0.2
(1 row)

-- edit postgresql.conf ...

regression=# select pg_reload_conf();
 pg_reload_conf
----------------
 t
(1 row)

regression=# show autovacuum_vacuum_scale_factor;
 autovacuum_vacuum_scale_factor
--------------------------------
 0.25
(1 row)

regression=#

Are you sure you're editing the right copy of postgresql.conf?

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

Reply via email to