On Thu, 2009-05-14 at 20:25 +0200, Dimitri wrote: > # lwlock_wait_8.4.d `pgrep -n postgres` > Lock Id Mode Combined Time (ns) > FirstLockMgrLock Exclusive 803700 > BufFreelistLock Exclusive 3001600 > FirstLockMgrLock Shared 4586600 > FirstBufMappingLock Exclusive 6283900 > FirstBufMappingLock Shared 21792900 I've published two patches to -Hackers to see if we can improve the read only numbers on 32+ cores. Try shared_buffer_partitions = 256 -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
