Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 15B7C633308
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Mon,  4 Jan 2010 15:48:38 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 88855-01
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Mon,  4 Jan 2010 19:48:24 +0000 (UTC)
X-Greylist: delayed 00:16:51.893289 by SQLgrey-1.7.6
Received: from polaris.pinpointresearch.com
	(66-7-238-130.static-ip.telepacific.net [66.7.238.130])
	by mail.postgresql.org (Postfix) with ESMTP id 6B3B7632D25
	for <pgsql-performance@postgresql.org>;
	Mon,  4 Jan 2010 15:48:27 -0400 (AST)
Received: from betelgeuse.pinpointresearch.com
	(betelgeuse.pinpointresearch.com [192.168.1.179])
	by polaris.pinpointresearch.com (Postfix) with ESMTP id B546BE047AFB;
	Mon,  4 Jan 2010 11:31:33 -0800 (PST)
Message-ID: <4B424215.70605@pinpointresearch.com>
Date: Mon, 04 Jan 2010 11:31:33 -0800
From: Steve Crawford <scrawford@pinpointresearch.com>
User-Agent: Thunderbird 2.0.0.23 (X11/20090817)
MIME-Version: 1.0
To: Madison Kelly <linux@alteeve.com>
CC: pgsql-performance@postgresql.org
Subject: Re: DB is slow until DB is reloaded
References: <4B423D22.7040803@alteeve.com>
In-Reply-To: <4B423D22.7040803@alteeve.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.38 tagged_above=-10 required=5 tests=AWL=-2.809,
	BAYES_50=0.001, FH_DATE_PAST_20XX=3.188
X-Spam-Level: 
X-Archive-Number: 201001/8
X-Sequence-Number: 36888

Madison Kelly wrote:
> Hi all,
>
>   I've got a fairly small DB...
>
>   It slows down over time and I can't seem to find a way to get the
> performance to return without doing a dump and reload of the database...

Some questions:

Is autovacuum running? This is the most likely suspect. If not, things 
will bloat and you won't be getting appropriate "analyze" runs. Speaking 
of which, what happens if you just run "analyze"?

And as long as you are dumping and reloading anyway, how about version 
upgrading for bug reduction, performance improvement, and cool new features.

Cheers,
Steve