From: Gregory Stark <stark@enterprisedb.com>
To: Josh Berkus <josh@agliodbs.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Alvaro Herrera <alvherre@commandprompt.com>
Cc: Heikki Linnakangas <heikki@enterprisedb.com>
Cc: pgsql-hackers@postgresql.org
Cc: Robert Treat <xzilla@users.sourceforge.net>
Cc: Peter Eisentraut <peter_e@gmx.net>
Cc: Greg Smith <gsmith@gregsmith.com>
Cc: Andreas Pflug <pgadmin@pse-consulting.de>
Cc: Decibel! <decibel@decibel.org>
Subject: Re: Overhauling GUCS
Date: Thu, 12 Jun 2008 02:01:49 +0100
Message-ID: <87k5gv4gaq.fsf@oxford.xeocode.com> (raw)
In-Reply-To: <48506FD4.7020804@agliodbs.com>
References: <48409D1E.3070208@agliodbs.com>
<200806061624.29105.xzilla@users.sourceforge.net>
<200806100937.38124.josh@agliodbs.com>
<200806100949.17918.josh@agliodbs.com>
<21875.1213122184@sss.pgh.pa.us>
<484F7613.5070202@enterprisedb.com>
<484FFF06.9010307@agliodbs.com>
<20080611163847.GN5352@alvh.no-ip.org>
<11913.1213218315@sss.pgh.pa.us>
<87od674hy6.fsf@oxford.xeocode.com>
<48506FD4.7020804@agliodbs.com>
"Josh Berkus" <josh@agliodbs.com> writes:
> Greg,
>
>> At least that way we could always steal more if we want or return some, as
>> long as we're careful about when we do it. That would open the door to having
>> these parameters be dynamically adjustable. That alone would be worthwhile
>> even if we bypass all bells and whistles of the buffer manager.
>>
>
> One hitch, though, is that asynchronous commit could consume big chunks of
> shared_buffers. So we might still need a limit for people who are using async.
Well currently we use a fixed number of fixed-sized buffers, no? I doubt we'll
change that even if we take this tact of making wal_buffers resizable by
stealing buffers from the buffer manager for precisely the reasons Tom was
describing.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's RemoteDBA services!
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-hackers@postgresql.org
Cc: stark@enterprisedb.com, josh@agliodbs.com, tgl@sss.pgh.pa.us, alvherre@commandprompt.com, heikki@enterprisedb.com, xzilla@users.sourceforge.net, peter_e@gmx.net, gsmith@gregsmith.com, pgadmin@pse-consulting.de, decibel@decibel.org
Subject: Re: Overhauling GUCS
In-Reply-To: <87k5gv4gaq.fsf@oxford.xeocode.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