| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | pg(at)fastcrypt(dot)com, Robert Creager <Robert_Creager(at)LogicalChaos(dot)org>, Dirk_Lutzebäck <lutzeb(at)aeccom(dot)com>, ohp(at)pyrenet(dot)fr, Joe Conway <mail(at)joeconway(dot)com>, "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>, pgsql-performance(at)postgresql(dot)org, Neil Conway <neilc(at)samurai(dot)com> |
| Subject: | Re: Wierd context-switching issue on Xeon |
| Date: | 2004-05-20 21:52:07 |
| Message-ID: | 200405201452.07833.josh@agliodbs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Guys,
> Oh, you wanted a fix? That seems harder :-(. AFAICS we need a redesign
> that causes less load on the BufMgrLock.
FWIW, we've been pursuing two routes of quick patch fixes.
1) Dave Cramer and I have been testing setting varying rates of spin_delay in
an effort to find a "sweet spot" that the individual system seems to like.
This has been somewhat delayed by my illness.
2) The OSDL folks have been trying various patches to use Linux 2.6 Futexes in
place of semops (if I have that right) which, if successful, would produce a
linux-specific fix. However, they haven't yet come up wiith a version of
the patch which is stable.
I'm really curious, BTW, about how all of Jan's changes to buffer usage in 7.5
affect this issue. Has anyone tested it on a recent snapshot?
--
-Josh Berkus
Aglio Database Solutions
San Francisco
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-05-20 22:14:52 | Re: Wierd context-switching issue on Xeon |
| Previous Message | Joseph Shraibman | 2004-05-20 16:52:13 | Re: PostgreSQL performance in simple queries |