From: Greg Smith <gsmith@gregsmith.com>
To: Jignesh K. Shah <J.K.Shah@Sun.COM>
Cc: Josh Berkus <josh@agliodbs.com>
Cc: pgsql-hackers@postgresql.org
Subject: Re: Overhauling GUCS
Date: Mon, 2 Jun 2008 12:47:42 -0400 (EDT)
Message-ID: <Pine.GSO.4.64.0806021227100.4018@westnet.com> (raw)
In-Reply-To: <484418D9.5040608@sun.com>
References: <48409D1E.3070208@agliodbs.com>
<1212219274.4120.191.camel@ebony.site>
<484418D9.5040608@sun.com>
On Mon, 2 Jun 2008, Jignesh K. Shah wrote:
> Most people I have seen will increase one or few but not all parameters
> related to memory which can result in loss of performance and
> productivity in figuring out.
If it becomes easier to build a simple tool available to help people tune
their configurations, that should help here without having to do anything
more complicated than that.
> What happened to AvailRAM setting and base all memory gucs on that.
Like some of the other GUC simplification ideas that show up sometimes
(unifying all I/O and limiting background processes based on that total is
another), this is hard to do internally. Josh's proposal has a fair
amount of work involved, but the code itself doesn't need to be clever or
too intrusive. Unifying all the memory settings would require being both
clever and intrusive, and I doubt you'll find anybody who could pull it
off who isn't already overtasked with more important improvements for the
8.4 timeframe.
--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD
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: gsmith@gregsmith.com, J.K.Shah@Sun.COM, josh@agliodbs.com
Subject: Re: Overhauling GUCS
In-Reply-To: <Pine.GSO.4.64.0806021227100.4018@westnet.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