| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Richard Troy <rtroy(at)ScienceTools(dot)com> |
| Cc: | creimer(at)brturbo(dot)com(dot)br, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Context switch storm |
| Date: | 2006-11-03 14:05:49 |
| Message-ID: | 454B4CBD.7080204@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Richard Troy wrote:
> On Fri, 3 Nov 2006, Richard Huxton wrote:
>> It's memory bandwidth issues on the older Xeons. If you search the
>> archives you'll see a lot of discussion of this. I'd have thought 8.1
>> would be better than 7.4 though.
>
> Hmmm... I just checked; one of our production systems is a multi-cpu Xeon
> based system of uncertain age (nobody remember 'zactly). While we haven't
> seen this problem yet, it's scheduled to take over demo-duty shortly and
> it would be an embarassment if we had this trouble during a demo... Is
> there any easy way to tell if you're at risk?
Try:
- multiple clients
- query doing sorts that fit into work_mem
--
Richard Huxton
Archonet Ltd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Troy | 2006-11-03 14:10:21 | Re: Context switch storm |
| Previous Message | Andreas Kostyrka | 2006-11-03 13:53:02 | Re: Context switch storm |