| From: | "Alaa El Gohary" <alaaelgohary(at)bftech(dot)com(dot)eg> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #2543: Performance delay acrros the same day |
| Date: | 2006-07-21 07:41:02 |
| Message-ID: | 200607210741.k6L7f2VL074357@wwwmaster.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-performance |
The following bug has been logged online:
Bug reference: 2543
Logged by: Alaa El Gohary
Email address: alaaelgohary(at)bftech(dot)com(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tino Schwarze | 2006-07-21 12:30:55 | initdb problem on Windows - SOLVED |
| Previous Message | David Fetter | 2006-07-21 03:08:00 | Re: BUG #2542: ALTER USER foo SET bar = func(baz) errors out |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Lor | 2006-07-21 07:56:56 | Re: Sun Donated a Sun Fire T2000 to the PostgreSQL |
| Previous Message | Tom Lane | 2006-07-20 19:01:58 | Re: Sun Donated a Sun Fire T2000 to the PostgreSQL |