pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedcontext-switching issue on Xeon
3+ messages / 3 participants
[nested] [flat]
* context-switching issue on Xeon
@ 2005-07-19 18:23 Sailer, Denis (YBUSA-CDR) <Denis.Sailer@Yellowbook.com>
2005-07-19 18:38 ` Re: context-switching issue on Xeon David Hodgkinson <daveh@hodgkinson.org>
2005-07-19 18:40 ` Re: context-switching issue on Xeon Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 2 replies; 3+ messages in thread
From: Sailer, Denis (YBUSA-CDR) @ 2005-07-19 18:23 UTC (permalink / raw)
To: pgsql-performance
The thread below has the test case that we were able to use to reproduce
the issue.
http://archives.postgresql.org/pgsql-performance/2004-04/msg00280.php
The last messages on this subject are from April of 2005. Has there
been any successful ways to significantly reduce the impact this has to
multi-processing? I haven't been able to find anything showing a
resolution of some kind.
We are seeing this on two of our machines:
Quad 3.0 GHz XEON with 3GB of memory running PG 7.4.3 with SuSE kernel
2.4
Dual 2.8 GHz XEON with 2GB of memory running PG 8.0.0 with SuSE kernel
2.4
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: context-switching issue on Xeon
2005-07-19 18:23 context-switching issue on Xeon Sailer, Denis (YBUSA-CDR) <Denis.Sailer@Yellowbook.com>
@ 2005-07-19 18:38 ` David Hodgkinson <daveh@hodgkinson.org>
1 sibling, 0 replies; 3+ messages in thread
From: David Hodgkinson @ 2005-07-19 18:38 UTC (permalink / raw)
To: Sailer, Denis (YBUSA-CDR) <Denis.Sailer@Yellowbook.com>; +Cc: pgsql-performance
FWIW, I'm seeing this with a client at the moment. 40-60k CS per second
on Dual 3.2GHz.
There are plenty of other issues we're dealing with, but this is
obviously
disconcerting...
On 19 Jul 2005, at 19:23, Sailer, Denis (YBUSA-CDR) wrote:
> The thread below has the test case that we were able to use to
> reproduce the issue.
>
>
> http://archives.postgresql.org/pgsql-performance/2004-04/msg00280.php
>
>
> The last messages on this subject are from April of 2005. Has
> there been any successful ways to significantly reduce the impact
> this has to multi-processing? I haven’t been able to find anything
> showing a resolution of some kind.
>
>
> We are seeing this on two of our machines:
>
>
> Quad 3.0 GHz XEON with 3GB of memory running PG 7.4.3 with SuSE
> kernel 2.4
>
>
> Dual 2.8 GHz XEON with 2GB of memory running PG 8.0.0 with SuSE
> kernel 2.4
>
>
>
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: context-switching issue on Xeon
2005-07-19 18:23 context-switching issue on Xeon Sailer, Denis (YBUSA-CDR) <Denis.Sailer@Yellowbook.com>
@ 2005-07-19 18:40 ` Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 0 replies; 3+ messages in thread
From: Tom Lane @ 2005-07-19 18:40 UTC (permalink / raw)
To: Sailer, Denis (YBUSA-CDR) <Denis.Sailer@Yellowbook.com>; +Cc: pgsql-performance
"Sailer, Denis (YBUSA-CDR)" <Denis.Sailer@Yellowbook.com> writes:
> http://archives.postgresql.org/pgsql-performance/2004-04/msg00280.php
> The last messages on this subject are from April of 2005. Has there
> been any successful ways to significantly reduce the impact this has to
> multi-processing?
CVS tip should largely fix the problem as far as buffer manager
contention goes.
> I haven't been able to find anything showing a
> resolution of some kind.
Look at the Feb/March threads concerning buffer manager rewrite, clock
sweep, etc ... eg
http://archives.postgresql.org/pgsql-patches/2005-03/msg00015.php
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2005-07-19 18:40 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-07-19 18:23 context-switching issue on Xeon Sailer, Denis (YBUSA-CDR) <Denis.Sailer@Yellowbook.com>
2005-07-19 18:38 ` David Hodgkinson <daveh@hodgkinson.org>
2005-07-19 18:40 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox