Oops, not my day :-) many thanks, Marc Mamin -----Original Message----- From: Guillaume Lelarge [mailto:guillaume@xxxxxxxxxxxx] Sent: Montag, 12. September 2011 12:16 To: Marc Mamin Cc: pgsql-admin@xxxxxxxxxxxxxx Subject: Re: how can I get "initial_value"(setting_name) ? On Mon, 2011-09-12 at 11:59 +0200, Marc Mamin wrote: > differentiated memory settings > > Hello, > > I need to implement differentiate memory settings in order to favor some > given operations. > (see function below) > > I miss an admin function to reset the settings to the initial values. > > Do I oversight something ? > > For the case such a function is not yet available, I guess that > following may prove useful: > > - reset_setting (setting_name [, is_local]) See RESET command (http://www.postgresql.org/docs/9.0/interactive/sql-reset.html). > - (read)initial_value(setting_name) > See pg_settings catalog (http://www.postgresql.org/docs/9.0/interactive/view-pg-settings.html, columns boot_val and reset_val). -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
