Postgres Pro
Downloads
Home   >   mailing lists

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

From Raghavendra
Subject Re: Why vacumming performed on template1 with initdb command ?
Date
Msg-id CA+h6AhgDWncgJomA2FDNX3Ur_LYoO1VWmnecX98XSZ-eDROmYA@mail.gmail.com
Whole thread Raw
In response to Re: Why vacumming performed on template1 with initdb command ?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view

On Thu, Dec 22, 2011 at 5:00 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
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

Got it... Thank you for briefing Tom... 

---
Regards,
Raghavendra
EnterpriseDB Corporation


pgsql-general by date:

Previous
From: Misa Simic
Date:
Subject: Re: design help for performance
Next
From: Havasvölgyi Ottó
Date:
Subject: Re: fsync on ext4 does not work