From: Jeff Davis <pgsql@j-davis.com>
To: Tobias Brox <tobias@nordicbet.com>
Cc: Paul Lathrop <plathrop@squaretrade.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Defining performance.
Date: Thu, 30 Nov 2006 16:57:54 -0800
Message-ID: <1164934674.7773.148.camel@dogma.v10.wvs> (raw)
In-Reply-To: <20061201000537.GA15466@oppetid.no>
References: <456F624F.2090906@squaretrade.com>
<20061201000537.GA15466@oppetid.no>
On Fri, 2006-12-01 at 01:05 +0100, Tobias Brox wrote:
> > However, we still are suffering a gradual decrease in performance over
> > time - or so the application engineers claim. The DBA and I have been
> > banging our heads against this for a month.
>
> 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?
Regards,
Jeff Davis
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: pgsql@j-davis.com, tobias@nordicbet.com, plathrop@squaretrade.com
Subject: Re: Defining performance.
In-Reply-To: <1164934674.7773.148.camel@dogma.v10.wvs>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox