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