Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 5CC9F9FB1E7 for ; Sun, 3 Jun 2007 15:28:32 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 59570-01-10 for ; Sun, 3 Jun 2007 15:28:28 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 29F3F9FB442 for ; Sun, 3 Jun 2007 15:25:32 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from hunley.homeip.net (hunley.homeip.net [69.12.222.146]) by svr4.postgresql.org (Postfix) with ESMTP id 3DF955AF9EA for ; Sun, 3 Jun 2007 17:39:21 +0000 (GMT) Received: from douglas.hunley.homeip.net (d60-34-189.col.wideopenwest.com [65.60.189.34]) (authenticated bits=0) by hunley.homeip.net (8.13.1/8.13.1) with ESMTP id l53HTHcb008251 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Sun, 3 Jun 2007 13:29:18 -0400 From: Douglas J Hunley To: Tom Lane Subject: Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x Date: Sun, 3 Jun 2007 13:29:07 -0400 User-Agent: KMail/1.9.7 Cc: pgsql-performance@postgresql.org References: <200706020913.32241.doug@hunley.homeip.net> <8862.1180797911@sss.pgh.pa.us> In-Reply-To: <8862.1180797911@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200706031329.07857.doug@hunley.homeip.net> X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (hunley.homeip.net [69.12.222.146]); Sun, 03 Jun 2007 13:29:18 -0400 (EDT) X-Virus-Scanned: ClamAV 0.88.7/3342/Sun Jun 3 10:10:41 2007 on hunley.homeip.net X-Virus-Status: Clean X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/21 X-Sequence-Number: 25054 On Saturday 02 June 2007 11:25:11 Tom Lane wrote: > Another thing that seems strange is that the 8.2 config file does not > seem to have been processed by initdb --- or did you explicitly comment > out the settings it made? I don't understand this comment. You are saying 'initdb' will make changes to the file? The file I sent is the working copy from the machine in question. -- Douglas J Hunley (doug at hunley.homeip.net) - Linux User #174778 http://doug.hunley.homeip.net "Does it worry you that you don't talk any kind of sense?"