Re: [PERFORM] Vacuum template databases, Urgent: Production problem

2006-03-14 Thread Jim C. Nasby
On Tue, Mar 14, 2006 at 11:44:12AM -0500, Pallav Kalva wrote: > Hi, > > Do we have to vacuum template0 database regularly ? We got this warning > this morning while vacuuming databases. As a part of my daily vacuum job > I do vacuum of quartz, helix_fdc and affiliate databases which are t

Re: [PERFORM] Vacuum template databases, Urgent: Production problem

2006-03-14 Thread Tom Lane
Pallav Kalva <[EMAIL PROTECTED]> 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 ---