On 4 Sep 2003 at 10:53, [EMAIL PROTECTED] wrote: > http://developer.osdl.org/markw/44/ > > I threw together (kind of sloppily) a web page of the data I was > starting to collect for our DBT-2 workload (TPC-C derivative) on > PostgreSQL 7.3.4. Keep in mind not much database tuning has been done > yet. Feel free to ask any questions.
You should set effective cache size to bit more realistic than 1000. That's just 8MB. I would also suggest you setting autocommit to off, in case that makes any difference. If the application is entirely managing it's own transactions explicitly this should not make any difference. If youhave good disks like SCSI/IDE RAID or above, you can reduce random_page_cost to 2 or even less. For heavily updated systems, you should have WAL buffers bit more. I don't know exact imact of that setting though. You could try 32/64/128. On the same note, if you are getting checkpoints too frequently, you can try increasing checkpoint segments. The logs will tell as such. HTH Bye Shridhar -- QOTD: "When she hauled ass, it took three trips." ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
