Re: Wierd context-switching issue on Xeon

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Jeff <threshar(at)torgo(dot)978(dot)org>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Joe Conway <mail(at)joeconway(dot)com>, Neil Conway <neilc(at)samurai(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com>, lutzeb(at)aeccom(dot)com, pgsql-performance(at)postgresql(dot)org, "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
Subject: Re: Wierd context-switching issue on Xeon
Date: 2004-04-20 13:06:59
Message-ID: 1082466419.3069.132.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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(at)jefftrout(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Bill Moran 2004-04-20 13:14:00 Re: Why will vacuum not end?
Previous Message Shea,Dan [CIS] 2004-04-20 12:58:09 Re: Why will vacuum not end?