Re: DB is slow until DB is reloaded

From: Craig James <craig_james(at)emolecules(dot)com>
To: Madison Kelly <linux(at)alteeve(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: DB is slow until DB is reloaded
Date: 2010-01-05 04:02:10
Message-ID: 4B42B9C2.7050303@emolecules.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

+Madison Kelly wrote:
> You are right, autovacuum is not running after all. From your comment, I
> am wondering if you'd recommend I turn it on or not? If so, given that I
> doubt I will upgrade any time soon, how would I enable it? I suppose I
> could google that, but google rarely shares gotcha's. :)

Most of the pain of a Postgres upgrade is the dump/reload step. But you've already had to do that several times, so why the hesitation to upgrade? Upgrading Postgres to the latest release, even if you have to do it from the source code, takes almost no time at all compared to the time you've already burned trying to solve this problem. Do the upgrade, you won't regret it.

Craig

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2010-01-05 05:14:09 Re: pg_connect takes 3.0 seconds
Previous Message Greg Smith 2010-01-05 03:01:54 Re: pg_connect takes 3.0 seconds