Autovac _scale_ settings not changed by SIGHUP?

From: Jerry Sievers <jerry(at)jerrysievers(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Autovac _scale_ settings not changed by SIGHUP?
Date: 2007-04-12 16:31:16
Message-ID: m3abxdimgb.fsf@mama.jerrysievers.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Guy Rouillier 2007-04-12 16:52:25 Re: Oracle mailing lists
Previous Message Merlin Moncure 2007-04-12 15:49:09 Re: SQL - finding next date