| From: | Bill Montgomery <billm(at)lulu(dot)com> |
|---|---|
| To: | Michael Adler <adler(at)pobox(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Excessive context switching on SMP Xeons |
| Date: | 2004-10-07 18:48:45 |
| Message-ID: | 41658F8D.9090204@lulu.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Michael Adler wrote:
>On Thu, Oct 07, 2004 at 11:48:41AM -0400, Bill Montgomery wrote:
>
>
>>Alan Stange wrote:
>>
>>The same test on a Dell PowerEdge 1750, Dual Xeon 3.2 GHz, 512k cache,
>>HT on, Linux 2.4.21-20.ELsmp (RHEL 3), 4GB memory, pg 7.4.5:
>>
>>Far less performance that the Dual Opterons with a low number of
>>clients, but the gap narrows as the number of clients goes up. Anyone
>>smarter than me care to explain?
>>
>>
>
>You'll have to wait for someone smarter than you, but I will posit
>this: Did you use a tmpfs filesystem like Alan? You didn't mention
>either way. Alan did that as an attempt remove IO as a variable.
>
>-Mike
>
>
Yes, I should have been more explicit. My goal was to replicate his
experiment as closely as possible in my environment, so I did run my
postgres data directory on a tmpfs.
-Bill Montgomery
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mischa Sandberg | 2004-10-07 20:00:04 | Re: sequential scan on select distinct |
| Previous Message | Alan Stange | 2004-10-07 18:28:54 | Re: Excessive context switching on SMP Xeons |