Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 17CE39F9479 for ; Sun, 4 Nov 2007 12:28:36 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 64868-01 for ; Sun, 4 Nov 2007 12:28:31 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from kuber.nabble.com (kuber.nabble.com [216.139.236.158]) by postgresql.org (Postfix) with ESMTP id 2B39F9F9477 for ; Sun, 4 Nov 2007 12:28:31 -0400 (AST) Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1IoiKs-0006Me-4o for pgsql-performance@postgresql.org; Sun, 04 Nov 2007 08:28:30 -0800 Message-ID: <13575017.post@talk.nabble.com> Date: Sun, 4 Nov 2007 08:28:30 -0800 (PST) From: smiley2211 To: pgsql-performance@postgresql.org Subject: Postgresql.conf Settings MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: smiley2211@yahoo.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=3.405 tagged_above=0 required=5 tests=AWL=-1.336, BAYES_40=-0.185, DNS_FROM_OPENWHOIS=1.13, FORGED_YAHOO_RCVD=2.297, WHOIS_MYPRIVREG=1.499 X-Spam-Level: *** X-Archive-Number: 200711/46 X-Sequence-Number: 27461 Hello all, What are the ideal settings for values in this postgresql.conf file??? I have tried so many parameter changes but I still can not get the 8.1.4 version to perform as well as the 7.x version...what do others have their postgrsql.conf file values set to??? Are there any known performance degrades going from 7.x to 8.1 versions??? Thanks...Michelle -- View this message in context: http://www.nabble.com/Postgresql.conf-Settings-tf4747486.html#a13575017 Sent from the PostgreSQL - performance mailing list archive at Nabble.com.