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

Re: Wierd context-switching issue on Xeon

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pg(at)fastcrypt(dot)com, Dirk_Lutzebäck <lutzeb(at)aeccom(dot)com>
Cc: ohp(at)pyrenet(dot)fr, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,Joe Conway <mail(at)joeconway(dot)com>,"scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>,Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>,pgsql-performance(at)postgresql(dot)org, Neil Conway <neilc(at)samurai(dot)com>
Subject: Re: Wierd context-switching issue on Xeon
Date: 2004-04-21 17:29:43
Message-ID: 200404211029.43675.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-performance
Dave,

> After some testing if you use the current head code for s_lock.c which
> has some mods in it to alleviate this situation, and change
> SPINS_PER_DELAY to 10 you can drastically reduce the cs with tom's test.
> I am seeing a slight degradation in throughput using pgbench -c 10 -t
> 1000 but it might be liveable, considering the alternative is unbearable
> in some situations.
>
> Can anyone else replicate my results?

Can you produce a patch against 7.4.1?   I'd like to test your fix against a 
real-world database.


-- 
Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Responses

pgsql-performance by date

Next:From: Josh BerkusDate: 2004-04-21 17:31:31
Subject: Fwd: Re: [PERFORM] MySQL vs PG TPC-H benchmarks
Previous:From: Qing ZhaoDate: 2004-04-21 17:01:30
Subject: Re: Shared buffers, Sort memory, Effective Cache Size

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