Received: from localhost (maia-3.hub.org [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id 33C2B9FA2CA
	for <pgsql-bugs-postgresql.org@postgresql.org>;
	Mon, 27 Nov 2006 22:59:13 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024)
	with ESMTP id 98223-08 for <pgsql-bugs-postgresql.org@postgresql.org>;
	Mon, 27 Nov 2006 22:59:03 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130])
	by postgresql.org (Postfix) with ESMTP id BE84B9FA23F
	for <pgsql-bugs@postgresql.org>; Mon, 27 Nov 2006 22:59:08 -0400 (AST)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id kAS2x62R027599;
	Mon, 27 Nov 2006 21:59:06 -0500 (EST)
To: "Michael Simms" <michael@tuxgames.com>
cc: pgsql-bugs@postgresql.org
Subject: Re: BUG #2784: Performance serious degrades over a period of a month 
In-reply-to: <200611261635.kAQGZqKE025405@wwwmaster.postgresql.org> 
References: <200611261635.kAQGZqKE025405@wwwmaster.postgresql.org>
Comments: In-reply-to "Michael Simms" <michael@tuxgames.com>
	message dated "Sun, 26 Nov 2006 16:35:52 +0000"
Date: Mon, 27 Nov 2006 21:59:06 -0500
Message-ID: <27598.1164682746@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200611/216
X-Sequence-Number: 16351

"Michael Simms" <michael@tuxgames.com> writes:
> OK, we have a database that runs perfectly well after a dump and restore,
> but over a period of a month or two, it just degrades to the point of
> uselessness.
> vacuumdb -a is run every 24 hours. We have also run for months at a time
> using -a -z but the effect doesnt change.

You probably need significantly-more-frequent vacuuming.  Have you
considered autovacuum?

This is not a bug --- you'd get better help on the pgsql-performance
mailing list.

			regards, tom lane