Re: Issue with Linux+Pentium SMP Context Switching - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Issue with Linux+Pentium SMP Context Switching
Date
Msg-id 200312191117.31743.josh@agliodbs.com
Whole thread Raw
In response to Re: Issue with Linux+Pentium SMP Context Switching  (Kurt Roeckx <Q@ping.be>)
Responses Re: Issue with Linux+Pentium SMP Context Switching
List pgsql-hackers
Kurt,

> This is without any other query running, right?  I even find 5000
> cs/s rather large if there isn't any other process that wants
> some CPU.

Sorry!   Darn!

Important fact left out of the problem description:  The issue happens when 
*two or more* intensive queries are running simultaneosly.

> To me this can only make sense in case there is an other backend
> trying to use the same memory, and it needs to be moved from 1
> CPU to an other.

Yes.   See above.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco


pgsql-hackers by date:

Previous
From: Randolf Richardson
Date:
Subject: Re: *sigh*
Next
From: Chongbing Liu
Date:
Subject: How can I return a pointer to a use structure from a function