Re: Issue with Linux+Pentium SMP Context Switching

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Kurt Roeckx <Q(at)ping(dot)be>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Issue with Linux+Pentium SMP Context Switching
Date: 2003-12-19 19:17:31
Message-ID: 200312191117.31743.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message elein 2003-12-19 19:32:09 Re: PostgreSQL speakers needed for OSCON 2004
Previous Message Kurt Roeckx 2003-12-19 19:07:27 Re: Issue with Linux+Pentium SMP Context Switching