The following bug has been logged online:

Bug reference: 2543
Logged by: Alaa El Gohary
Email address: alaaelgohary (AT) bftech (DOT) com.eg
PostgreSQL version: 7.4.12
Operating system: FreeBSD 6.0
Description: Performance delay acrros the same day
Details:

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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

On Fri, Jul 21, 2006 at 07:41:02 +0000,
Alaa El Gohary <alaaelgohary (AT) bftech (DOT) com.eg> wrote:
The report below isn't a bug, its a performance question and should have
been sent to pgsql-performance (AT) postgresql (DOT) org. I am redirecting replies there.

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 majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly