Re: Rather large Postgres directory

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: jd(at)commandprompt(dot)com
Cc: william pink <will(dot)pink(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Rather large Postgres directory
Date: 2009-04-29 22:01:38
Message-ID: dcc563d10904291501k1528e30j35946b10b2d80069@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, Apr 29, 2009 at 4:00 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
> On Wed, Apr 29, 2009 at 9:59 AM, Joshua D. Drake <jd(at)commandprompt(dot)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.

'was turned OFF by default in 8.1'

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Jan-Peter Seifert 2009-04-29 22:17:59 Re: Copy source and header files... ./config.sh: line 137: stem.c: No such file or directory
Previous Message Scott Marlowe 2009-04-29 22:00:14 Re: Rather large Postgres directory