From: Carlos Moreno <moreno_pg@mochima.com>
To: pgsql-performance@postgresql.org
Subject: Re: strange performance regression between 7.4 and 8.1
Date: Fri, 02 Mar 2007 08:56:59 -0500
Message-ID: <45E82D2B.3030100@mochima.com> (raw)
In-Reply-To: <82slco6n9t.fsf@mid.bfk.de>
References: <a728f9f90703011244r577d56d7y422ab4bd71bb760e@mail.gmail.com>
<82slco6n9t.fsf@mid.bfk.de>
Florian Weimer wrote:
> * Alex Deucher:
>
>
>> I have noticed a strange performance regression and I'm at a loss as
>> to what's happening. We have a fairly large database (~16 GB).
>>
>
> Sorry for asking, but is this a typo? Do you mean 16 *TB* instead of
> 16 *GB*?
>
> If it's really 16 GB, you should check if it's cheaper to buy more RAM
> than to fiddle with the existing infrastructure.
>
This brings me to a related question:
Do I need to specifically configure something to take advantage of
such increase of RAM?
In particular, is the amount of things that postgres can do with RAM
limited by the amount of shared_buffers or some other parameter?
Should shared_buffers be a fixed fraction of the total amount of
physical RAM, or should it be the total amount minus half a gigabyte
or so?
As an example, if one upgrades a host from 1GB to 4GB, what would
be the right thing to do in the configuration, assuming 8.1 or 8.2? (at
least what would be the critical aspects?)
Thanks,
Carlos
--
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-performance@postgresql.org
Cc: moreno_pg@mochima.com
Subject: Re: strange performance regression between 7.4 and 8.1
In-Reply-To: <45E82D2B.3030100@mochima.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