Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Defining performance.
- From: Jeff Davis <pgsql(at)j-davis(dot)com>
- To: Tobias Brox <tobias(at)nordicbet(dot)com>
- Cc: Paul Lathrop <plathrop(at)squaretrade(dot)com>, pgsql-performance(at)postgresql(dot)org
- Subject: Re: Defining performance.
- Date: Thu, 30 Nov 2006 16:57:54 -0800
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
- Follow-Ups:
- Re: Defining performance.
- From: Tobias Brox
- Re: Defining performance.
- References:
- Defining performance.
- From: Paul Lathrop
- Re: Defining performance.
- From: Tobias Brox
- Defining performance.
- Prev by Date: Bad iostat numbers
- Next by Date: Re: Defining performance.
- Previous by thread: Re: Defining performance.
- Next by thread: Re: Defining performance.
- Indexes: