Skip site navigation (1) Skip section navigation (2)

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: 2006-07-21 07:41:02
Message-ID: 200607210741.k6L7f2VL074357@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-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

Responses

pgsql-performance by date

Next:From: Robert LorDate: 2006-07-21 07:56:56
Subject: Re: Sun Donated a Sun Fire T2000 to the PostgreSQL
Previous:From: Tom LaneDate: 2006-07-20 19:01:58
Subject: Re: Sun Donated a Sun Fire T2000 to the PostgreSQL

pgsql-bugs by date

Next:From: Tino SchwarzeDate: 2006-07-21 12:30:55
Subject: initdb problem on Windows - SOLVED
Previous:From: David FetterDate: 2006-07-21 03:08:00
Subject: Re: BUG #2542: ALTER USER foo SET bar = func(baz) errors out

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group