Skip site navigation (1) Skip section navigation (2)

Re: First set of OSDL Shared Mem scalability results, some wierdness

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Subject: Re: First set of OSDL Shared Mem scalability results, some wierdness
Date: 2004-10-10 09:25:23
Message-ID: 41690003.2010905@bigfoot.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-performance
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





In response to

pgsql-performance by date

Next:From: Dennis BjorklundDate: 2004-10-10 21:48:48
Subject: Re: First set of OSDL Shared Mem scalability results, some
Previous:From: Gaetano MendolaDate: 2004-10-10 09:19:59
Subject: kernel 2.6 synchronous directory

pgsql-hackers by date

Next:From: David GaramondDate: 2004-10-10 11:07:54
Subject: Re: postgres vulnerability
Previous:From: Gaetano MendolaDate: 2004-10-10 09:13:27
Subject: Re: postgres vulnerability

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group