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