| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | Robert Creager <Robert_Creager(at)LogicalChaos(dot)org> |
| Cc: | pg(at)fastcrypt(dot)com, Dirk_Lutzebäck <lutzeb(at)aeccom(dot)com>, 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-29 18:21:51 |
| Message-ID: | 200404291121.51247.josh@agliodbs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Rob,
> I would like to see the same, as I have a system that exhibits the same
behavior
> on a production db that's running 7.4.1.
If you checked the thread follow-ups, you'd see that *decreasing*
spins_per_delay was not beneficial. Instead, try increasing them, one step
at a time:
(take baseline measurement at 100)
250
500
1000
1500
2000
3000
5000
... until you find an optimal level. Then report the results to us!
--
-Josh Berkus
Aglio Database Solutions
San Francisco
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rod Taylor | 2004-04-29 19:12:15 | Re: planner/optimizer question |
| Previous Message | Gary Doades | 2004-04-29 18:13:51 | Re: planner/optimizer question |