If one adds the '-a' arg to vacuumdb wouldn't that vacuum all databases including template1?
Tim
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Tom Lane
Sent: Tuesday, March 14, 2006 12:28 PM
To: Pallav Kalva
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Vacuum template databases, Urgent: Production problem
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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
