Re: fatal error on 8.1 server - Mailing list pgsql-general

From Russell Smith
Subject Re: fatal error on 8.1 server
Date
Msg-id 4572426D.5000203@pws.com.au
Whole thread Raw
In response to Re: fatal error on 8.1 server  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane wrote:
> Alvaro Herrera <alvherre@commandprompt.com> writes:
>
>> Tony Caduto wrote:
>>
>>> I did not have autovacuum turned on and I usually do a vacuumdb -z -a -f
>>> -q  each night but this one slipped through the cracks :-(
>>>
>
>
>> Strange -- autovacuum should have started an automatic database-wide
>> vacuum on that database, even if disabled.
>>
>
> We only added that in 8.2, no?  8.1 autovacuum would have forced the
> vacuum to occur, but only if it was enabled in postgresql.conf.
>
And in 8.2 it's only a per table vacuum that is required.  Is that
correct too?
>             regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq
>
>
>


pgsql-general by date:

Previous
From: Shane Ambler
Date:
Subject: Re: named cache
Next
From:
Date:
Subject: Re: select query not using index