X-Original-To: pgsql-bugs-postgresql.org@postgresql.org
Received: from localhost (wm.hub.org [200.46.204.128])
	by postgresql.org (Postfix) with ESMTP id 0E5819FA42F
	for <pgsql-bugs-postgresql.org@postgresql.org>;
	Fri, 21 Jul 2006 04:41:12 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024)
	with ESMTP id 52081-02 for <pgsql-bugs-postgresql.org@postgresql.org>;
	Fri, 21 Jul 2006 07:41:04 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from wwwmaster.postgresql.org (wwwmaster.postgresql.org
	[65.19.161.25]) by postgresql.org (Postfix) with ESMTP id 289329FA425
	for <pgsql-bugs@postgresql.org>; Fri, 21 Jul 2006 04:41:03 -0300 (ADT)
Received: from wwwmaster.postgresql.org (wwwmaster.postgresql.org
	[65.19.161.25])
	by wwwmaster.postgresql.org (8.13.3/8.13.3) with ESMTP id
	k6L7f2h9074358
	for <pgsql-bugs@postgresql.org>; Fri, 21 Jul 2006 07:41:02 GMT
	(envelope-from www@wwwmaster.postgresql.org)
Received: (from www@localhost)
	by wwwmaster.postgresql.org (8.13.3/8.13.3/Submit) id k6L7f2VL074357;
	Fri, 21 Jul 2006 07:41:02 GMT (envelope-from www)
Date: Fri, 21 Jul 2006 07:41:02 GMT
Message-Id: <200607210741.k6L7f2VL074357@wwwmaster.postgresql.org>
To: pgsql-bugs@postgresql.org
Subject: BUG #2543: Performance delay acrros the same day
From: "Alaa El Gohary" <alaaelgohary@bftech.com.eg>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.2 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE
X-Spam-Level: 
X-Archive-Number: 200607/94
X-Sequence-Number: 15439


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