pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Dave Cramer <pg@fastcrypt.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Paul Tuckfield <paul@tuckfield.com>
Cc: Anjan Dave <adave@vantage.com>
Cc: Josh Berkus <josh@agliodbs.com>
Cc: Neil Conway <neilc@samurai.com>
Cc: Dirk Lutzebäck <lutzeb@aeccom.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Wierd context-switching issue on Xeon patch for 7.4.1
Date: Wed, 21 Apr 2004 23:06:41 -0400
Message-ID: <1082603201.1556.272.camel@localhost.localdomain> (raw)
In-Reply-To: <18322.1082601330@sss.pgh.pa.us>
References: <4BAFBB6B9CC46F41B2AD7D9F4BBAF78509814A@vt-pe2550-001.vantage.vantage.com>
	<200404200959.52813.josh@agliodbs.com>
	<1082515263.1558.214.camel@localhost.localdomain>
	<78427208-93C0-11D8-BA67-000393BD6C3E@tuckfield.com>
	<1082574808.1558.243.camel@localhost.localdomain>
	<1082580588.13371.260.camel@localhost.localdomain>
	<18322.1082601330@sss.pgh.pa.us>

Yeah, I did some more testing myself, and actually get better numbers
with increasing spins per delay to 1000, but my suspicion is that it is
highly dependent on finding the right delay for the processor you are
on.

My hypothesis is that if you spin approximately the same or more time
than the average time it takes to get finished with the shared resource
then this should reduce cs.

Certainly more ideas are required here.

Dave 
On Wed, 2004-04-21 at 22:35, Tom Lane wrote:
> Dave Cramer <pg@fastcrypt.com> writes:
> > diff -c -r1.16 s_lock.c
> > *** backend/storage/lmgr/s_lock.c	8 Aug 2003 21:42:00 -0000	1.16
> > --- backend/storage/lmgr/s_lock.c	21 Apr 2004 20:27:34 -0000
> > ***************
> > *** 76,82 ****
> >   	 * The select() delays are measured in centiseconds (0.01 sec) because 10
> >   	 * msec is a common resolution limit at the OS level.
> >   	 */
> > ! #define SPINS_PER_DELAY		100
> >   #define NUM_DELAYS			1000
> >   #define MIN_DELAY_CSEC		1
> >   #define MAX_DELAY_CSEC		100
> > --- 76,82 ----
> >   	 * The select() delays are measured in centiseconds (0.01 sec) because 10
> >   	 * msec is a common resolution limit at the OS level.
> >   	 */
> > ! #define SPINS_PER_DELAY		10
> >   #define NUM_DELAYS			1000
> >   #define MIN_DELAY_CSEC		1
> >   #define MAX_DELAY_CSEC		100
> 
> 
> As far as I can tell, this does reduce the rate of semop's
> significantly, but it does so by bringing the overall processing rate
> to a crawl :-(.  I see 97% CPU idle time when using this patch.
> I believe what is happening is that the select() delay in s_lock.c is
> being hit frequently because the spin loop isn't allowed to run long
> enough to let the other processor get out of the spinlock.
> 
> 			regards, tom lane
> 
> 
> 
> !DSPAM:40872f7e21492906114513!
> 
> 
-- 
Dave Cramer
519 939 0336
ICQ # 14675561




view thread (22+ messages)  latest in thread

Message-ID: <1082603201.1556.272.camel@localhost.localdomain>
Permalink:  ../1082603201.1556.272.camel@localhost.localdomain/
Also on:    postgresql.org/message-id/1082603201.1556.272.camel@localhost.localdomain

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: pg@fastcrypt.com, tgl@sss.pgh.pa.us, paul@tuckfield.com, adave@vantage.com, josh@agliodbs.com, neilc@samurai.com, lutzeb@aeccom.com
  Subject: Re: Wierd context-switching issue on Xeon patch for 7.4.1
  In-Reply-To: <1082603201.1556.272.camel@localhost.localdomain>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox