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) -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin