Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 331539FBA27 for ; Mon, 4 Jun 2007 09:45:06 -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 69906-10 for ; Mon, 4 Jun 2007 09:45:03 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.168]) by postgresql.org (Postfix) with ESMTP id 2349F9FBB72 for ; Mon, 4 Jun 2007 09:45:02 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id u2so846724uge for ; Mon, 04 Jun 2007 05:45:01 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding:sender; b=bt4WnvQi2pi3aoPIIi81xTKmnw/P8umQp4pPaeSXDcrnfq3hV4zIxLp4E0D7RaB3KuR1SA/73MfqehYzt7Has24hCUr7JEdbs74oDrFxnQcuEbV6+cMNtyKj93pU4rAK6jJqdLoy2mDsMJcz5Cl17R8BhJkzY7TH8d9KSuur6Cc= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding:sender; b=kEfKYb9PietHKGjs0+HmWCFp+z+io3OdGQRkomy0NxX4/p2RTdAKPjhVFyUWTCuKnTrerCa2tFJOpRYqtw0o3kHXx1/pLVsTbxvNgnZhjV4a5QjOSq0cCx064YIQl64WTP84/R5fvq/qeXTicyfgb0W0bxBI2Fb0nlttphsSUgc= Received: by 10.67.116.15 with SMTP id t15mr3076042ugm.1180961101623; Mon, 04 Jun 2007 05:45:01 -0700 (PDT) Received: from ?172.24.32.33? ( [62.232.55.118]) by mx.google.com with ESMTP id j1sm458943ugf.2007.06.04.05.44.56; Mon, 04 Jun 2007 05:44:58 -0700 (PDT) Message-ID: <46640934.40801@enterprisedb.com> Date: Mon, 04 Jun 2007 13:44:36 +0100 From: Heikki Linnakangas User-Agent: Icedove 1.5.0.10 (X11/20070329) MIME-Version: 1.0 To: Douglas J Hunley CC: Luke Lonergan , Tom Lane , pgsql-performance@postgresql.org Subject: Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x References: <200706040840.39550.doug@hunley.homeip.net> In-Reply-To: <200706040840.39550.doug@hunley.homeip.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/26 X-Sequence-Number: 25059 Douglas J Hunley wrote: > On Sunday 03 June 2007 16:39:51 Luke Lonergan wrote: >> When you initdb, a config file is edited from the template by initdb to >> reflect your machine config. > > I didn't realize that. I'll have to harass the rest of the team to see if > someone overwrote that file or not. In the interim, I did an 'initdb' to > another location on the same box and then copied those values into the config > file. That's cool to do, I assume? Yeah, that's ok. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com