Re: Wierd context-switching issue on Xeon - Mailing list pgsql-performance

From Robert Creager
Subject Re: Wierd context-switching issue on Xeon
Date
Msg-id 20040502092047.029525f6@thunder.mshome.net
Whole thread Raw
In response to Re: Wierd context-switching issue on Xeon  (Dave Cramer <pg@fastcrypt.com>)
Responses Re: Wierd context-switching issue on Xeon
List pgsql-performance
Found some co-workers at work yesterday to load up my library...

The sample period is 5 minutes long (vs 2 minutes previously):

Context switches -          avg    max

Default 7.4.1 code :       48784 107354
Default patch - 10 :       20400  28160
patch at 100       :       38574  85372
patch at 1000      :       41188 106569

The reading at 1000 was not produced under the same circumstances as the prior
readings as I had to replace my device under test with a simulated one.  The
real one died.

The previous run with smaller database and 120 second averages:

Context switches -          avg    max

Default 7.4.1 code :       10665  69470
Default patch - 10 :       17297  21929
patch at 100       :       26825  87073
patch at 1000      :       37580 110849

--
 20:13:50 up 3 days,  2:58,  4 users,  load average: 2.12, 2.14, 2.10
Linux 2.6.5-01 #7 SMP Fri Apr 16 22:45:31 MDT 2004

Attachment

pgsql-performance by date:

Previous
From: "Jochem van Dieten"
Date:
Subject: Re: planner/optimizer question
Next
From: Dave Cramer
Date:
Subject: Re: Wierd context-switching issue on Xeon