pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jan Wieck <JanWieck@Yahoo.com>
To: Greg Stark <gsstark@mit.edu>
Cc: Christopher Browne <cbbrowne@acm.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: First set of OSDL Shared Mem scalability results, some
Date: Thu, 14 Oct 2004 00:17:34 -0400
Message-ID: <416DFDDE.5070600@Yahoo.com> (raw)
In-Reply-To: <871xg25538.fsf@stark.xeocode.com>
References: <200410081443.16109.josh@agliodbs.com>
	<m31xg8zlo4.fsf@wolfe.cbbrowne.com>
	<416DCCFF.70304@Yahoo.com>
	<871xg25538.fsf@stark.xeocode.com>

On 10/13/2004 11:52 PM, Greg Stark wrote:

> Jan Wieck <JanWieck@Yahoo.com> writes:
> 
>> On 10/8/2004 10:10 PM, Christopher Browne wrote:
>> 
>> > josh@agliodbs.com (Josh Berkus) wrote:
>> >> I've been trying to peg the "sweet spot" for shared memory using
>> >> OSDL's equipment.  With Jan's new ARC patch, I was expecting that
>> >> the desired amount of shared_buffers to be greatly increased.  This
>> >> has not turned out to be the case.
>> > That doesn't surprise me.
>> 
>> Neither does it surprise me.
> 
> There's been some speculation that having a large shared buffers be about 50%
> of your RAM is pessimal as it guarantees the OS cache is merely doubling up on
> all the buffers postgres is keeping. I wonder whether there's a second sweet
> spot where the postgres cache is closer to the total amount of RAM.

Which would require that shared memory is not allowed to be swapped out, 
and that is allowed in Linux by default IIRC, not to completely distort 
the entire test.


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #



view thread (41+ messages)  latest in thread

Message-ID: <416DFDDE.5070600@Yahoo.com>
Permalink:  ../416DFDDE.5070600@Yahoo.com/
Also on:    postgresql.org/message-id/416DFDDE.5070600@Yahoo.com

 · 

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-performance@postgresql.org
  Cc: JanWieck@Yahoo.com, gsstark@mit.edu, cbbrowne@acm.org
  Subject: Re: First set of OSDL Shared Mem scalability results, some
  In-Reply-To: <416DFDDE.5070600@Yahoo.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