Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 0E02B9FA17A for ; Thu, 30 Nov 2006 21:08:02 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 11826-08 for ; Thu, 30 Nov 2006 21:07:56 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from lynet.oppetid.no (oppetid.no [80.65.51.2]) by postgresql.org (Postfix) with ESMTP id 8E3009FA282 for ; Thu, 30 Nov 2006 21:07:56 -0400 (AST) Received: by lynet.oppetid.no (Postfix, from userid 1019) id A221211AFE3; Fri, 1 Dec 2006 02:07:54 +0100 (CET) Date: Fri, 1 Dec 2006 02:07:54 +0100 From: Tobias Brox To: Jeff Davis Cc: Tobias Brox , Paul Lathrop , pgsql-performance@postgresql.org Subject: Re: Defining performance. Message-ID: <20061201010754.GA1448@oppetid.no> References: <456F624F.2090906@squaretrade.com> <20061201000537.GA15466@oppetid.no> <1164934674.7773.148.camel@dogma.v10.wvs> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1164934674.7773.148.camel@dogma.v10.wvs> Organization: Group Nordicbet User-Agent: Mutt/1.5.9i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/280 X-Sequence-Number: 22050 [Jeff Davis - Thu at 04:57:54PM -0800] > > We're having the same issues, so we do the dumping and restoring every > > now and then to be sure everything is properly cleaned up. With 8.1. > > > > What's causing that? Is it index bloat? > > I would think a REINDEX would avoid having to dump/restore, right? A > CLUSTER might also be necessary, depending on what kind of performance > degradation you're experiencing. > > Am I missing something? Just as with Paul Lathrops case, the performance degradation is something perceived by the application developers. We haven't had time to actually verify reliably that the performance is actually beeing degraded, neither that the reload beeing done helps (after we resolved the pending transaction issue, anyway), nor look into what the possible reasons of this percieved degradation could be.