Re: vacuum confusion - Mailing list pgsql-general

From John Sidney-Woollett
Subject Re: vacuum confusion
Date
Msg-id 420CD9B9.2060803@wardbrook.com
Whole thread Raw
In response to Re: vacuum confusion  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Thanks Tom, I figured it out after I saw the error message when trying
to vacuum template0.

I think the 7.4.x docs could do with a more explanation.

The 8.0 docs are better although a more explicit explanation stating
that you MUST vacuum analyze template1 (periodically) would be useful.

Thanks

John Sidney-Woollett

Tom Lane wrote:

> John Sidney-Woollett <johnsw@wardbrook.com> writes:
>
>>However the implication (and my confusion) is that you need to vacuum
>>your own databases only. It's not clear (to me) that you have to do the
>>same for template0 and template1 as well.
>
>
> You have to vacuum template1, but not template0 because the latter is
> marked not datallowconn.  Not sure if this is adequately explained
> anywhere.  The next-to-last para in section 21.1.3 does mention the
> datallowconn exception, but perhaps doesn't spell it out well enough.
>
>             regards, tom lane

pgsql-general by date:

Previous
From: Brad Nicholson
Date:
Subject: Re: how to capture query?
Next
From: Yury Don
Date:
Subject: Re: how to capture query?