Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id E86E42E008D for ; Fri, 9 May 2008 16:19:49 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 94619-04 for ; Fri, 9 May 2008 16:19:44 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mout.perfora.net (mout.perfora.net [74.208.4.197]) by developer.postgresql.org (Postfix) with ESMTP id B1A652E008C for ; Fri, 9 May 2008 16:19:46 -0300 (ADT) Received: from [198.212.166.61] ([198.212.166.61]) by mrelay.perfora.net (node=mrus0) with ESMTP (Nemesis) id 0MKp8S-1JuY8817bU-00026z; Fri, 09 May 2008 15:19:45 -0400 Message-ID: <4824A3FA.9030702@the-allgoods.net> Date: Fri, 09 May 2008 15:20:26 -0400 From: John Allgood User-Agent: Thunderbird 2.0.0.12 (X11/20080226) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Upgrading from 7.4.19 to 8.3.1 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Provags-ID: V01U2FsdGVkX1+6dlcMgktkxEqjVsKhvTRURMXcC6y17a8nmTO 1Z3gL0l7SCXkxX6Eld/bravDmVTP1b4vJztElTHzYBNMJ+306N YRSwxN4wlzsa94TEOCrrsBNAmqFhbXa4CD5E1XHTT8= X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200805/72 X-Sequence-Number: 29156 Hello All We are upgrading from Postgres 7.4.19 to 8.3.1 and wanted to know as for Tuning the database what options in the postgresql.conf have changed or have been added that I will need to adjust. Example shared buffers, sort memory and vacuum and others. Also we are planning on using autovacuum and would like some input on what other users on the list are doing. I know this a vague question. but I see many differences between the two config files and wanted input. Thanks John Allgood