Dump / restore for optimization?

From: lec <limec(at)streamyx(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Dump / restore for optimization?
Date: 2004-06-24 16:01:05
Message-ID: 40DAFAC1.1090409@streamyx.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I always have to dump & restore to make a database (which is in use for
a few months) efficient again. I have scheduled nightly vacuum analyze,
but only dump & restore can make the database efficient again. Has
anyone experience this?

-lec

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2004-06-24 16:05:06 Re: Queries not always using index on timestamp search
Previous Message Devrim GUNDUZ 2004-06-24 15:03:17 7.4.3 RPMS for RHEL3