Обсуждение: Re: Vacuum template databases, Urgent: Production probl

If one adds the '-a' arg to vacuumdb wouldn't that vacuum all databases including template1?

Tim

 -----Original Message-----
From:   pgsql-performance-owner@postgresql.org [mailto:pgsql-performance-owner@postgresql.org]  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 <pkalva@livedatagroup.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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@postgresql.org so that your
       message can get through to the mailing list cleanly

On Tue, Mar 14, 2006 at 12:28:17PM -0500, mcelroy, tim wrote:
> If one adds the '-a' arg to vacuumdb wouldn't that vacuum all databases
> including template1?

It does on 8.1...

decibel@phonebook.1[15:15]~:18%vacuumdb -va | & grep template1
vacuumdb: vacuuming database "template1"
decibel@phonebook.1[15:16]~:19%

Try it and find out.
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461