Horton

Re: Wierd context-switching issue on Xeon

Robert Creager <robert_creager@logicalchaos.org>

View thread
From: Robert Creager <Robert_Creager@LogicalChaos.org>
To: pg@fastcrypt.com
Cc: Josh Berkus <josh@agliodbs.com>, Dirk_Lutzebäck <lutzeb@aeccom.com>, ohp@pyrenet.fr, Tom Lane <tgl@sss.pgh.pa.us>, Joe Conway <mail@joeconway.com>, "scott.marlowe" <scott.marlowe@ihs.com>, Bruce Momjian <pgman@candle.pha.pa.us>, pgsql-performance@postgresql.org, Neil Conway <neilc@samurai.com>
Date: 2004-05-02T21:46:49Z
Lists: pgsql-performance 
When grilled further on (Sun, 02 May 2004 11:39:22 -0400),
Dave Cramer <pg@fastcrypt.com> confessed:

> Robert,
> 
> The real question is does it help under real life circumstances ? 

I'm not yet at the point where the CS's are causing appreciable delays.  I
should get there early this week and will be able to measure the relief your
patch may provide.

> 
> Did you do the tests with Tom's sql code that is designed to create high
> context switchs ?

No, I'm using my queries/data.

Cheers,
Rob

-- 
 10:44:58 up 3 days, 17:30,  4 users,  load average: 2.00, 2.04, 2.01
Linux 2.6.5-01 #7 SMP Fri Apr 16 22:45:31 MDT 2004