Re: Context Switching issue: Spinlock doesn't fix.

From: jelle <jellej(at)pacbell(dot)net>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Context Switching issue: Spinlock doesn't fix.
Date: 2004-08-31 21:20:41
Message-ID: Pine.LNX.4.44.0408311417070.14094-100000@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


Hello,

Is context switching problem resolved in 8.0?

Can I drop in another Xeon?

Thanks,
Jelle

On Wed, 2 Jun 2004, Josh Berkus wrote:

> Folks,
>
> I've been testing varying SPINS_PER_DELAY in a client's installation of
> PostgreSQL against a copy of a production database, to test varying this
> statistic as a way of fixing the issue.
>
> It does not seem to work.
>
> I've tested all of the following graduated levels:
>
> 100 (the original)
> 250
> 500
> 1000
> 2000
> 5000
> 10000
> 20000
> 30000
> 50000
>
> None of these quantities seem to make any difference at all in the number of
> context switches -- neither down nor up. Seems to me like this is a dead
> end. Does anyone have test results that show otherwise?
>
>

--

http://www.jibjab.com

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jim C. Nasby 2004-08-31 21:50:13 Re: Equivalent praxis to CLUSTERED INDEX?
Previous Message Hervé Piedvache 2004-08-31 20:41:15 Re: Optimizing a request