Re: Pgbench Performance on PGSQL

I notice from your postings on the PGSQL-hackers archives that you have been
experimenting with PGSQL and Pgbench. I have not been able to get PGSQL to
scale on multiple processors. Tom Lane says this is due to the
implementation of spin-locks. Have you made any fixes or additions to PGSQL
to improve scalability on multiple processors?

No.

Is there anything else I
should try?

The only thing I noticed to increase the performance so far is extend
the deadlock_timeout paramterter.

BTW, wal_sync_method parameter seems also impact the performance. I'm
not sure what kind of platform you are using, but from my experience
open_sync is the best for Unix, while fdatasync is good for Solaris.
--
Tatsuo Ishii