pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Guillaume Lelarge <guillaume@lelarge.info>
To: Marc Mamin <M.Mamin@intershop.de>
Cc: pgsql-admin@postgresql.org
Subject: Re: how can I get "initial_value"(setting_name) ?
Date: Mon, 12 Sep 2011 12:15:53 +0200
Message-ID: <1315822553.2708.11.camel@localhost.localdomain> (raw)
In-Reply-To: <C4DAC901169B624F933534A26ED7DF310861B099@JENMAIL01.ad.intershop.net>
References: <C4DAC901169B624F933534A26ED7DF310861B099@JENMAIL01.ad.intershop.net>

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

view thread (3+ messages)  latest in thread

Message-ID: <1315822553.2708.11.camel@localhost.localdomain>
Permalink:  ../1315822553.2708.11.camel@localhost.localdomain/
Also on:    postgresql.org/message-id/1315822553.2708.11.camel@localhost.localdomain

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: guillaume@lelarge.info, M.Mamin@intershop.de
  Subject: Re: how can I get "initial_value"(setting_name) ?
  In-Reply-To: <1315822553.2708.11.camel@localhost.localdomain>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox