Re: Issue with Linux+Pentium SMP Context Switching

From: Kurt Roeckx <Q(at)ping(dot)be>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Issue with Linux+Pentium SMP Context Switching
Date: 2003-12-20 00:23:54
Message-ID: 20031220002354.GA27173@ping.be
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Dec 19, 2003 at 11:17:31AM -0800, Josh Berkus wrote:
>
> Important fact left out of the problem description: The issue happens when
> *two or more* intensive queries are running simultaneosly.

So two queries are enough to get this problem?

I assume the tables are so big that they don't fit in shared
memory and it needs to go read in the data? So that the problem
only shows itself when it needs to replace buffers?

If it doesn't have to go read, do you still have the problem?

Kurt

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2003-12-20 00:37:26 Re: PostgreSQL speakers needed for OSCON 2004
Previous Message Bruce Momjian 2003-12-20 00:05:15 Re: Project status pages