Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
BUG #2543: Performance delay acrros the same day
- 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: Fri, 21 Jul 2006 07:41:02 GMT
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
- Follow-Ups:
- Re: BUG #2543: Performance delay acrros the same day
- From: Bruno Wolff III
- Re: BUG #2543: Performance delay acrros the same day
- Prev by Date: Re: BUG #2542: ALTER USER foo SET bar = func(baz) errors out
- Next by Date: initdb problem on Windows - SOLVED
- Previous by thread: BUG #2542: ALTER USER foo SET bar = func(baz) errors out
- Next by thread: Re: BUG #2543: Performance delay acrros the same day
- Indexes: