Postgres Pro
Downloads
Home   >   mailing lists

Re: Rather large Postgres directory - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: Rather large Postgres directory
Date
Msg-id dcc563d10904291500o51b0e44l7da120b977e8fbc4@mail.gmail.com
Whole thread Raw
In response to Re: Rather large Postgres directory  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-admin
Tree view 
On Wed, Apr 29, 2009 at 9:59 AM, Joshua D. Drake <jd@commandprompt.com> wrote:

> At this point you may be better off just doing a backup and restore and
> then figure out why your maintenance routines are failing.

OP said he was running 8.1.  I think autovacuum was turned on by
default on 8.1, so first step after dump restore is to turn on
autovacuum.

pgsql-admin by date:

Previous
From: Kenneth Marshall
Date:
Subject: Re: CLUSTER not in multi-command string?
Next
From: Michael Monnerie
Date:
Subject: Re: Rather large Postgres directory