Hello All, We are building a web based application which is database intensive (we intend to use postgresql). Expect about 600 concurrent users. We are using Zope and python with postgresql on RedHat Enterprise Linux. Our server has dual intel xeon 2.4 GHz and 2 Gig Ram with lots of disk space with hardware raid.
I would appreciate all help to get the best possible performance from postgresql, we will be using a lot of views and a lot of pl/pgsql procedures. I am looking at good rules to use for memory, WAL, SQL Transaction Isolation Levels and cache configuration along with anything else that I have missed. Thank you in advance for all your help, Mohan A. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster