Postgres Pro
Downloads
Home   >   mailing lists

Re: Vacuum template databases, Urgent: Production problem - Mailing list pgsql-performance

From Tom Lane
Subject Re: Vacuum template databases, Urgent: Production problem
Date
Msg-id 20780.1142357270@sss.pgh.pa.us
Whole thread Raw
In response to Vacuum template databases, Urgent: Production problem  (Pallav Kalva <pkalva@livedatagroup.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Pallav Kalva
Date:
Subject: Vacuum template databases, Urgent: Production problem
Next
From: "mcelroy, tim"
Date:
Subject: Re: Vacuum template databases, Urgent: Production probl