pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #2543: Performance delay acrros the same day
3+ messages / 3 participants
[nested] [flat]
* BUG #2543: Performance delay acrros the same day
@ 2006-07-21 07:41 Alaa El Gohary <alaaelgohary@bftech.com.eg>
0 siblings, 1 reply; 3+ messages in thread
From: Alaa El Gohary @ 2006-07-21 07:41 UTC (permalink / raw)
To: pgsql-bugs@postgresql.org
The following bug has been logged online:
Bug reference: 2543
Logged by: Alaa El Gohary
Email address: alaaelgohary@bftech.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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: BUG #2543: Performance delay acrros the same day
@ 2006-07-21 18:33 Bruno Wolff III <bruno@wolff.to>
parent: Alaa El Gohary <alaaelgohary@bftech.com.eg>
0 siblings, 1 reply; 3+ messages in thread
From: Bruno Wolff III @ 2006-07-21 18:33 UTC (permalink / raw)
To: Alaa El Gohary <alaaelgohary@bftech.com.eg>; +Cc: pgsql-bugs@postgresql.org; pgsql-performance
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: BUG #2543: Performance delay acrros the same day
@ 2006-07-24 07:54 Markus Schaber <schabi@logix-tt.com>
parent: Bruno Wolff III <bruno@wolff.to>
0 siblings, 0 replies; 3+ messages in thread
From: Markus Schaber @ 2006-07-24 07:54 UTC (permalink / raw)
To: pgsql-performance@postgresql.org, Alaa El Gohary <alaaelgohary@bftech.com.eg>; bruno@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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2006-07-24 07:54 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-07-21 07:41 BUG #2543: Performance delay acrros the same day Alaa El Gohary <alaaelgohary@bftech.com.eg>
2006-07-21 18:33 ` Bruno Wolff III <bruno@wolff.to>
2006-07-24 07:54 ` Markus Schaber <schabi@logix-tt.com>
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