It's interesting that people focus on shared_buffers. From my experience the most dominating parameter for performance is wal_sync_method. It sometimes makes ~20% performance difference. On the otherhand, shared_buffers does very little for performance. Moreover too many shared_buffers cause performance degration! I guess this is due to the poor design of bufmgr. Until it is fixed, just increasing the number of shared_buffers a bit, say 1024, is enough IMHO. -- Tatsuo Ishii
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
