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
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