Re: Postgres Performance - Mailing list pgsql-admin

From hubert depesz lubaczewski
Subject Re: Postgres Performance
Date
Msg-id 20080320103615.GA10677@depesz.com
Whole thread Raw
In response to Postgres Performance  (Aftab Alam <aalam@tsrdarashaw.com>)
List pgsql-admin
On Thu, Mar 20, 2008 at 04:02:48PM +0530, Aftab Alam wrote:
> I have mistaken written 7.0 instead of 7.3, I am getting more than 2000 hits
> daily, can u suggest the best configuration. Mean while I am trying to
> migrate it to 8.3.1

7.3 is also pretty old.
as for 2000 hits daily - it's not much. do you have performance issues?
check which queries couse the problems, and "explain analyze" them.
then, with explain analyze output, you can fix performance issues in
those queries.

regards,

depesz

--
quicksil1er: "postgres is excellent, but like any DB it requires a
highly paid DBA.  here's my CV!" :)
http://www.depesz.com/ - blog dla ciebie (i moje CV)

pgsql-admin by date:

Previous
From: Aftab Alam
Date:
Subject: Re: Postgres Performance
Next
From: Vishal Arora
Date:
Subject: Re: Postgres Performance