pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Gaetano Mendola <mendola@bigfoot.com>
To: Josh Berkus <josh@agliodbs.com>
Subject: Re: First set of OSDL Shared Mem scalability results, some wierdness
Date: Sun, 10 Oct 2004 11:25:23 +0200
Message-ID: <41690003.2010905@bigfoot.com> (raw)
In-Reply-To: <200410081443.16109.josh@agliodbs.com>
References: <200410081443.16109.josh@agliodbs.com>

Josh Berkus wrote:
> Folks,
> 
> I'm hoping that some of you can shed some light on this.
> 
> 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.
> 
> The first test series was using OSDL's DBT2 (OLTP) test, with 150 
> "warehouses".   All tests were run on a 4-way Pentium III 700mhz 3.8GB RAM 
> system hooked up to a rather high-end storage device (14 spindles).    Tests 
> were on PostgreSQL 8.0b3, Linux 2.6.7.

I'd like to see these tests running using the cpu affinity capability in order
to oblige a backend to not change CPU during his life, this could drastically
increase the cache hit.


Regards
Gaetano Mendola







view thread (41+ messages)  latest in thread

Message-ID: <41690003.2010905@bigfoot.com>
Permalink:  ../41690003.2010905@bigfoot.com/
Also on:    postgresql.org/message-id/41690003.2010905@bigfoot.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: mendola@bigfoot.com, josh@agliodbs.com
  Subject: Re: First set of OSDL Shared Mem scalability results, some wierdness
  In-Reply-To: <41690003.2010905@bigfoot.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