Postgres Pro
Downloads
Home   >   mailing lists

Re: Why vacumming performed on template1 with initdb command ? - Mailing list pgsql-general

From Tom Lane
Subject Re: Why vacumming performed on template1 with initdb command ?
Date
Msg-id 1270.1324510233@sss.pgh.pa.us
Whole thread Raw
In response to Why vacumming performed on template1 with initdb command ?  (Raghavendra <raghavendra.rao@enterprisedb.com>)
Responses Re: Why vacumming performed on template1 with initdb command ?  (Raghavendra <raghavendra.rao@enterprisedb.com>)
List pgsql-general
Tree view 
Raghavendra <raghavendra.rao@enterprisedb.com> writes:
> Why vacuuming is performed on a new cluster on template1 database.

It's a VACUUM FREEZE, and if we didn't do it we'd have to do the work
over again later, separately in every database of the cluster.

            regards, tom lane

pgsql-general by date:

Previous
From: Roger Leigh
Date:
Subject: Re: Escaping input from COPY
Next
From: Misa Simic
Date:
Subject: Re: design help for performance