> I wrote:
> > The following proposal should improve performance substantially when
> > there is contention for a lock, but it creates no portability risks
> > ...
>
> I have committed changes to implement this proposal. I'm not seeing
> any significant performance difference on pgbench on my single-CPU
> system ... but pgbench is I/O bound anyway on this hardware, so that's
> not very surprising. I'll be interested to see what other people
> observe. (Tatsuo, care to rerun that 1000-client test?)
I ran with 20 clients:
$ pgbench -i test
$ pgbench -c 20 -t 100 test
and see no difference in tps performance between the two lock
implementations. I have a Dual PIII 550MHz i386 BSD/OS machine with
SCSI disks.
--
Bruce Momjian | http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
