Date: Fri, 21 Jul 2006 13:33:43 -0500
From: Bruno Wolff III <bruno@wolff.to>
To: Alaa El Gohary <alaaelgohary@bftech.com.eg>
Cc: pgsql-bugs@postgresql.org, pgsql-performance@postgresql.org
Subject: Re: BUG #2543: Performance delay acrros the same day
Message-ID: <20060721183343.GA21995@wolff.to>
Mail-Followup-To: pgsql-performance@postgresql.org,
	Alaa El Gohary <alaaelgohary@bftech.com.eg>, bruno@wolff.to
References: <200607210741.k6L7f2VL074357@wwwmaster.postgresql.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <200607210741.k6L7f2VL074357@wwwmaster.postgresql.org>
User-Agent: Mutt/1.4.2.1i

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.