From: | "Marc Mamin" <M(dot)Mamin(at)intershop(dot)de> |
---|---|
To: | "Guillaume Lelarge" <guillaume(at)lelarge(dot)info> |
Cc: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: how can I get "initial_value"(setting_name) ? |
Date: | 2011-09-12 10:30:58 |
Message-ID: | C4DAC901169B624F933534A26ED7DF310861B09A@JENMAIL01.ad.intershop.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Oops,
not my day :-)
many thanks,
Marc Mamin
-----Original Message-----
From: Guillaume Lelarge [mailto:guillaume(at)lelarge(dot)info]
Sent: Montag, 12. September 2011 12:16
To: Marc Mamin
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] 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
From | Date | Subject | |
---|---|---|---|
Next Message | Mokhtary, Mandana | 2011-09-12 11:38:39 | Encoding Problem |
Previous Message | Guillaume Lelarge | 2011-09-12 10:15:53 | Re: how can I get "initial_value"(setting_name) ? |