Tom Lane wrote:

Jeff <[EMAIL PROTECTED]> 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



---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to