Pallav Kalva <pkalva(at)livedatagroup(dot)com> writes:
> Do we have to vacuum template0 database regularly ?
No, and in fact you can't because it's marked not datallowconn.
But you do need to vacuum template1 and usps every now and then.
regards, tom lane