Postgres Pro
Downloads
Home   >   mailing lists

Thread: Autovac _scale_ settings not changed by SIGHUP?

Autovac _scale_ settings not changed by SIGHUP?

From
Jerry Sievers
Date:
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

Re: Autovac _scale_ settings not changed by SIGHUP?

From
Tom Lane
Date:
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

Re: Autovac _scale_ settings not changed by SIGHUP?

From
Jerry Sievers
Date:
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