From: Markus Schaber <schabi@logix-tt.com>
To: pgsql-performance@postgresql.org, Alaa El Gohary <alaaelgohary@bftech.com.eg>
To: bruno@wolff.to
Subject: Re: BUG #2543: Performance delay acrros the same day
Date: Mon, 24 Jul 2006 09:54:29 +0200
Message-ID: <44C47CB5.6080806@logix-tt.com> (raw)
In-Reply-To: <20060721183343.GA21995@wolff.to>
References: <200607210741.k6L7f2VL074357@wwwmaster.postgresql.org>
<20060721183343.GA21995@wolff.to>
Hi, Bruno,
Bruno Wolff III wrote:
> On Fri, Jul 21, 2006 at 07:41:02 +0000,
> Alaa El Gohary <alaaelgohary@bftech.com.eg> wrote:
>> The following bug has been logged online:
>
> The report below isn't a bug, its a performance question and should have
> been sent to pgsql-performance@postgresql.org. I am redirecting replies there.
>
>> A query on the postgresql DB takes about 5 seconds and then it starts to
>> take more time till it reaches about 60 seconds by the end of the same day.
>> I tried vacuum but nothing changed the only thing that works is to dump the
>> DB ,drop and create a new one with the dump taken.
>> i need to know if there is any way to restore the performance back without
>> the need for drop and create
>> cause i can't do this accross the day
>
> You most likely aren't vacuuming often enough and/or don't have your FSM
> setting high enough.
Depending on the PostgreSQL version, it might also be that he suffers
from index bloat. He might look into the manual pages about REINDEX for
a description.
HTH,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org
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: schabi@logix-tt.com, alaaelgohary@bftech.com.eg, bruno@wolff.to
Subject: Re: BUG #2543: Performance delay acrros the same day
In-Reply-To: <44C47CB5.6080806@logix-tt.com>
* 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