Re: Postgres Performance - Mailing list pgsql-admin

From hubert depesz lubaczewski
Subject Re: Postgres Performance
Date
Msg-id 20080320095714.GA9423@depesz.com
Whole thread Raw
In response to Postgres Performance  (Aftab Alam <aalam@tsrdarashaw.com>)
Responses Re: Postgres Performance  (Aftab Alam <aalam@tsrdarashaw.com>)
List pgsql-admin
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)

pgsql-admin by date:

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