pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Dave Cramer <pg@fastcrypt.com>
To: Jeff <threshar@torgo.978.org>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: Joe Conway <mail@joeconway.com>
Cc: Neil Conway <neilc@samurai.com>
Cc: Josh Berkus <josh@agliodbs.com>
Cc: lutzeb@aeccom.com, pgsql-performance@postgresql.org, "scott.marlowe" <scott.marlowe@ihs.com>
Subject: Re: Wierd context-switching issue on Xeon
Date: Tue, 20 Apr 2004 09:06:59 -0400
Message-ID: <1082466419.3069.132.camel@localhost.localdomain> (raw)
In-Reply-To: <B41A54FF-92C8-11D8-A8BE-000D9366F0C4@torgo.978.org>
References: <Pine.LNX.4.33.0404191410550.17372-100000@css120.ihs.com>
	<40843E63.7050101@joeconway.com>
	<200404191455.04068.josh@agliodbs.com>
	<1407.1082419316@sss.pgh.pa.us>
	<B41A54FF-92C8-11D8-A8BE-000D9366F0C4@torgo.978.org>

Dual Athlon

With one process running 30 cs/second
with two process running 15000 cs/second

Dave
On Tue, 2004-04-20 at 08:46, Jeff wrote:
> On Apr 19, 2004, at 8:01 PM, Tom Lane wrote:
> [test case]
> 
> Quad P3-700Mhz, ServerWorks, pg 7.4.2 - 1 process: 10-30 cs / second
>                   							   2 process: 100k cs / sec
> 								   3 process: 140k cs / sec
> 								   8 process: 115k cs / sec
> 
> Dual P2-450Mhz, non-serverworks (piix)  - 1 process 15-20 / sec
>              						            2 process 30k / sec
>            							  3 (up to 7) process: 15k /sec
> 
> (Yes, I verified with more processes the cs's drop)
> 
> And finally,
> 
> 6 cpu sun e4500, solaris 2.6, pg 7.4.2: 1 - 10 processes: hovered 
> between 2-3k cs/second (there was other stuff running on the machine as 
> well)
> 
> 
> Verrry interesting.
> I've got a dual G4 at home, but for convenience Apple doesn't ship a 
> vmstat that tells context switches
> 
> --
> Jeff Trout <jeff@jefftrout.com>
> http://www.jefftrout.com/
> http://www.stuarthamm.net/
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
>                http://www.postgresql.org/docs/faqs/FAQ.html
> 
> 
> 
> !DSPAM:40851da1199651145780980!
> 
> 
-- 
Dave Cramer
519 939 0336
ICQ # 14675561




view thread (77+ messages)  latest in thread

Message-ID: <1082466419.3069.132.camel@localhost.localdomain>
Permalink:  ../1082466419.3069.132.camel@localhost.localdomain/
Also on:    postgresql.org/message-id/1082466419.3069.132.camel@localhost.localdomain

 · 

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: pg@fastcrypt.com, threshar@torgo.978.org, tgl@sss.pgh.pa.us, pgman@candle.pha.pa.us, mail@joeconway.com, neilc@samurai.com, josh@agliodbs.com, scott.marlowe@ihs.com
  Subject: Re: Wierd context-switching issue on Xeon
  In-Reply-To: <1082466419.3069.132.camel@localhost.localdomain>

* 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