> 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?
> 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.
pgsql-hackers by date
|Next:||From: Tatsuo Ishii||Date: 2001-07-22 11:10:16|
|Subject: Re: Thai data import into PostgreSQL|
|Previous:||From: Domingo Alvarez Duarte||Date: 2001-07-22 10:16:55|
|Subject: unique index doesn't accept functions on fields|