From: Alaa El Gohary <alaaelgohary@bftech.com.eg>
To: pgsql-bugs@postgresql.org
Subject: BUG #2543: Performance delay acrros the same day
Date: Fri, 21 Jul 2006 07:41:02 GMT
Message-ID: <200607210741.k6L7f2VL074357@wwwmaster.postgresql.org> (raw)
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
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: alaaelgohary@bftech.com.eg, pgsql-bugs@postgresql.org
Subject: Re: BUG #2543: Performance delay acrros the same day
In-Reply-To: <200607210741.k6L7f2VL074357@wwwmaster.postgresql.org>
* 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