Jerry Sievers <jerry@jerrysievers.com> 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