Re: RESOLVED: Re: Wierd context-switching issue on Xeon - Mailing list pgsql-performance

From Tom Lane
Subject Re: RESOLVED: Re: Wierd context-switching issue on Xeon
Date
Msg-id 28603.1082123378@sss.pgh.pa.us
Whole thread Raw
In response to RESOLVED: Re: Wierd context-switching issue on Xeon  (Dirk Lutzebäck <lutzeb@aeccom.com>)
List pgsql-performance
=?ISO-8859-1?Q?Dirk_Lutzeb=E4ck?= <lutzeb@aeccom.com> writes:
> This was the key to look at: we were missing all indices on table which
> is used heavily and does lots of locking. After recreating the missing
> indices the production system performed normal. No, more excessive
> semop() calls, load way below 1.0, CS over 20.000 very rare, more in
> thousands realm and less.

Hmm ... that's darn interesting.  AFAICT the test case I am looking at
for Josh's client has no such SQL-level problem ... but I will go back
and double check ...

            regards, tom lane

pgsql-performance by date:

Previous
From: "Shea,Dan [CIS]"
Date:
Subject: Re: [ SOLVED ] select count(*) very slow on an already
Next
From: Tom Lane
Date:
Subject: Re: query slows down with more accurate stats