| From: | Jeff <threshar(at)torgo(dot)978(dot)org> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | 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(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 12:46:12 |
| Message-ID: | B41A54FF-92C8-11D8-A8BE-000D9366F0C4@torgo.978.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shea,Dan [CIS] | 2004-04-20 12:58:09 | Re: Why will vacuum not end? |
| Previous Message | Greg Sabino Mullane | 2004-04-20 11:15:58 | Re: Deleting certain duplicates |