From: | "mcelroy, tim" <tim(dot)mcelroy(at)bostonstock(dot)com> |
---|---|
To: | 'Tom Lane' <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Vacuum template databases, Urgent: Production probl |
Date: | 2006-03-14 17:28:17 |
Message-ID: | 0C4841B42F87D51195BD00B0D020F5CB044B246C@morpheus.bostonstock.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
If one adds the '-a' arg to vacuumdb wouldn't that vacuum all databases
including template1?
Tim
-----Original Message-----
From: pgsql-performance-owner(at)postgresql(dot)org
[mailto:pgsql-performance-owner(at)postgresql(dot)org] On Behalf Of Tom Lane
Sent: Tuesday, March 14, 2006 12:28 PM
To: Pallav Kalva
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: [PERFORM] Vacuum template databases, Urgent: Production
problem
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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly
From | Date | Subject | |
---|---|---|---|
Next Message | andremachado | 2006-03-14 18:33:20 | firebird X postgresql 8.1.2 windows, performance comparison |
Previous Message | Tom Lane | 2006-03-14 17:27:50 | Re: Vacuum template databases, Urgent: Production problem |