Re: Vacuum template databases, Urgent: Production problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Pallav Kalva <pkalva(at)livedatagroup(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Vacuum template databases, Urgent: Production problem
Date: 2006-03-14 17:27:50
Message-ID: 20780.1142357270@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message mcelroy, tim 2006-03-14 17:28:17 Re: Vacuum template databases, Urgent: Production probl
Previous Message Pallav Kalva 2006-03-14 16:44:12 Vacuum template databases, Urgent: Production problem