From: Joshua Tolley <eggyknap@gmail.com>
To: Robert Haas <robertmhaas@gmail.com>
Cc: pgsql-docs@postgresql.org
Subject: Re: commit_delay and commit_siblings -- restart or reload?
Date: Tue, 1 Jun 2010 15:50:21 -0600
Message-ID: <4c05809f.1472730a.06d1.600e@mx.google.com> (raw)
In-Reply-To: <AANLkTimW0kCLOsslenNpOyNN9Gmjf-6zVFVPu9chHdP9@mail.gmail.com>
References: <4c052c68.20a5720a.3577.33e6@mx.google.com>
<AANLkTimW0kCLOsslenNpOyNN9Gmjf-6zVFVPu9chHdP9@mail.gmail.com>
On Tue, Jun 01, 2010 at 03:33:24PM -0400, Robert Haas wrote:
> On Tue, Jun 1, 2010 at 11:51 AM, Joshua Tolley <eggyknap@gmail.com> wrote:
> > The documentation for commit_delay and commit_siblings doesn't mention whether
> > a reload or restart is required to set them. I recommend something like the
> > trivial attached docs patch to make it clear(er) that a reload is required.
>
> These parameters are PGC_USERSET - a reload is not the only way to change them.
>
> Of course, changing any parameter in postgresql.conf won't take effect
> unless you reload, but the point of that sentence, in the other places
> where we use it, is that you can't change those parameters using
> things like ALTER DATABASE ... SET, ALTER USER ... SET, just plain
> SET, etc.
Ah, you're right. My mistake -- thanks.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.comAttachments:
signature.asc (application/pgp-signature, 196B) download
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-docs@postgresql.org
Cc: eggyknap@gmail.com, robertmhaas@gmail.com
Subject: Re: commit_delay and commit_siblings -- restart or reload?
In-Reply-To: <4c05809f.1472730a.06d1.600e@mx.google.com>
* 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