John Sidney-Woollett <johnsw(at)wardbrook(dot)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