Re: Effects of pgbench "scale factor"

> 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