suggestions to improve performace

From: "Mohan A" <mohana(at)zeomega(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: suggestions to improve performace
Date: 2004-06-29 16:54:59
Message-ID: 3439.202.142.94.6.1088528099.squirrel@mail.zeomega.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2004-06-29 17:21:58 Re: no index-usage on aggregate-functions?
Previous Message Bill Montgomery 2004-06-29 16:22:42 Re: High load average with PostgreSQL 7.4.2 on debian/ibm