Re: Postgres Performance

Dear Hubert,

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

Regards
aftab

-----Original Message-----
From: hubert depesz lubaczewski [mailto:depesz(at)depesz(dot)com]
Sent: Thursday, March 20, 2008 3:27 PM
To: Aftab Alam
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Postgres Performance

On Thu, Mar 20, 2008 at 03:12:43PM +0530, Aftab Alam wrote:
> I am using postgres 7.0 with linux with 15 GB of database & 3
gb of RAM.
> Can anyone suggest what is the best setting for postgres. I am using
postgres as web db.

the best setting would be to upgrade.
7.0 was released in 2000, and is practically abandoned. the oldest
supported version at the moment is 7.4, but i would strongly suggest to
try to move to newest versions - like 8.3.1

regards,

hubert lubaczewski

--
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)

This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. TSR Darashaw Ltd. has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. TSR Darashaw Ltd. reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the TSR Darashaw Ltd's e-mail system.