> Based on these results I think that the spinlock and LWLock performance
> issues we have been discussing are not really as significant for
> real-world use as they appear when running pgbench with a small scale
> factor. My inclination right now is to commit the second variant of
> my LWLock patch, leave spinlock spinning where it is, and call it a
> day for 7.2. We can always revisit this stuff again in future
> development cycles.
I agree. 7.3 can bring more improvements like SMP detection, dead tuple
index markers, and lock granularity improvments. They are all on the
TODO list or in the 7.3 open items list.
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026