Обсуждение: Autovac _scale_ settings not changed by SIGHUP?
Perhaps I misunderstand something here. Autovac demon is configged on and working but was using standard settings which are commented out in postgresql.conf. The context field of pg_settings view suggests that the scale factor values and other autovac settings can be changed with SIGHUP. 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. Also did pg_ctl reload for good measure and nothing changed. Thanks -- ------------------------------------------------------------------------------- Jerry Sievers 732 365-2844 (work) Production Database Administrator 305 321-1144 (mobil WWW E-Commerce Consultant
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
Tom Lane <tgl@sss.pgh.pa.us> writes: > 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? Yes, the correct config files are being edited. . I do have egg on my face however. I forgot to mention that the platform and version was EnterpriseDB 8.1.4. Changing the configs by editing the file to uncomment and then change the value and HUPping does indeed work on Pg 8.2 as expected. <crawling under a rock>... Please pardon the omission. > regards, tom lane > -- ------------------------------------------------------------------------------- Jerry Sievers 732 365-2844 (work) Production Database Administrator 305 321-1144 (mobil WWW E-Commerce Consultant