Re: Postgres Performance

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)