Tom Lane wrote:
> Jeff <threshar@torgo.978.org> writes:
>
>>given that template0 and 1 rarely change.. I don't see why we'd need to
>>vacuum them
> You have to vacuum template1 periodically if you want pg_clog to shrink.
WOW, I saved 200 MB in one shoot vacuuming template 1 !
I learned this after 2 years of postgres, I'm a dummy.
Regards
Gaetano Mendola