| Lists: | pgsql-hackers |
|---|
| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Any conclusion on the Xeon context-switching issue? |
| Date: | 2006-02-27 16:21:08 |
| Message-ID: | 440326F4.5090405@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Subject says it all really. I've got a new client who seems to be
suffering from it, and I'm not sure if any conclusion was reached.
--
Richard Huxton
Archonet Ltd
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Richard Huxton <dev(at)archonet(dot)com> |
| Cc: | Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Any conclusion on the Xeon context-switching issue? |
| Date: | 2006-02-27 16:46:36 |
| Message-ID: | 19976.1141058796@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Richard Huxton <dev(at)archonet(dot)com> writes:
> Subject says it all really. I've got a new client who seems to be
> suffering from it, and I'm not sure if any conclusion was reached.
What's he using? 8.1 seems to have alleviated the problem somewhat,
and I've done more work in CVS tip. It'll never go away entirely,
because these chips are just not very good at sharing memory, but
we've certainly reduced it quite a bit from where it was in 7.x.
regards, tom lane
| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Any conclusion on the Xeon context-switching issue? |
| Date: | 2006-02-27 16:54:30 |
| Message-ID: | 44032EC6.8020103@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Tom Lane wrote:
> Richard Huxton <dev(at)archonet(dot)com> writes:
>> Subject says it all really. I've got a new client who seems to be
>> suffering from it, and I'm not sure if any conclusion was reached.
>
> What's he using? 8.1 seems to have alleviated the problem somewhat,
> and I've done more work in CVS tip. It'll never go away entirely,
> because these chips are just not very good at sharing memory, but
> we've certainly reduced it quite a bit from where it was in 7.x.
7.4.12 (.12 as of last week). I've seen context-switching peak at 80000
on a quad-Xeon that really shouldn't be straining.
An upgrade is possible, but obviously needs testing against. Would your
CVS changes be against 8.2-to-be or 8.1.x?
--
Richard Huxton
Archonet Ltd
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Richard Huxton <dev(at)archonet(dot)com> |
| Cc: | Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Any conclusion on the Xeon context-switching issue? |
| Date: | 2006-02-27 17:07:44 |
| Message-ID: | 20130.1141060064@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Richard Huxton <dev(at)archonet(dot)com> writes:
> Tom Lane wrote:
>> What's he using?
> 7.4.12 (.12 as of last week). I've seen context-switching peak at 80000
> on a quad-Xeon that really shouldn't be straining.
Try 8.1.3.
regards, tom lane
| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Any conclusion on the Xeon context-switching issue? |
| Date: | 2006-02-27 17:24:19 |
| Message-ID: | 440335C3.2070500@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Tom Lane wrote:
> Richard Huxton <dev(at)archonet(dot)com> writes:
>> Tom Lane wrote:
>>> What's he using?
>
>> 7.4.12 (.12 as of last week). I've seen context-switching peak at 80000
>> on a quad-Xeon that really shouldn't be straining.
>
> Try 8.1.3.
Thanks. I'll see if we can run a parallel installation overnight or
something.
--
Richard Huxton
Archonet Ltd
| From: | "Jeffrey W(dot) Baker" <jwbaker(at)acm(dot)org> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Any conclusion on the Xeon context-switching issue? |
| Date: | 2006-02-27 20:01:09 |
| Message-ID: | 1141070469.30381.5.camel@toonses.gghcwest.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
On Mon, 2006-02-27 at 16:54 +0000, Richard Huxton wrote:
> Tom Lane wrote:
> > Richard Huxton <dev(at)archonet(dot)com> writes:
> >> Subject says it all really. I've got a new client who seems to be
> >> suffering from it, and I'm not sure if any conclusion was reached.
> >
> > What's he using? 8.1 seems to have alleviated the problem somewhat,
> > and I've done more work in CVS tip. It'll never go away entirely,
> > because these chips are just not very good at sharing memory, but
> > we've certainly reduced it quite a bit from where it was in 7.x.
>
> 7.4.12 (.12 as of last week). I've seen context-switching peak at 80000
> on a quad-Xeon that really shouldn't be straining.
Is this causing an actual problem, or do you just like to see lower
numbers under the cs column? Certainly many people have asked about
this issue but few have pointed to application-level performance
problems that may have resulted.
-jwb