On Fri, Jul 21, 2006 at 07:41:02 +0000,
Alaa El Gohary <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] 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.
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
