Skip site navigation (1) Skip section navigation (2)

Re: futex

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Manfred Spraul <manfred(at)colorfullife(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: futex
Date: 2004-08-25 17:27:11
Message-ID: 200408251027.11101.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Manfred,

> What did you test exactly and could you explain a bit about the context
> switch storm?

PostgreSQL currently causes a CS storm (context switches > 100,000) on 
multi-processor machines where you have a number of concurrent processes ( > 
than the number of processors) accessing the same small quantity of data 
repeatedly, particularly if doing seq scans and/or bad queries.   This issue 
causes a significant drop in server performance, as much as 60%.  

> Did you use the futex interface directly or pthread_rwlock_rdlock?

I'll have to admit to having only a beginner's grasp of this stuff, but I do 
believe that that was what the OSDL patch did.   Jan also tried a simpler 
patch, which didn't work either.    Both Jan and Tom have expressed the 
opinion that the only solution is to make the BufrMgrLock more granular (as 
in, not monolithic) but this is a huge task.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco

In response to

  • Re: futex at 2004-08-25 17:14:53 from Manfred Spraul

Responses

  • Re: futex at 2004-08-25 22:26:28 from Neil Conway

pgsql-hackers by date

Next:From: Devrim GUNDUZDate: 2004-08-25 17:52:59
Subject: Re: rpm for RH AS 2.1 ?
Previous:From: Serguei A. MokhovDate: 2004-08-25 17:16:21
Subject: Typo in a comment in initdb.c

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group