Re: vacuum strategy - Mailing list pgsql-general

From Tom Lane
Subject Re: vacuum strategy
Date
Msg-id 7410.1038308521@sss.pgh.pa.us
Whole thread Raw
In response to Re: vacuum strategy  (Tina Messmann <tina.messmann@xinux.de>)
List pgsql-general
Tina Messmann <tina.messmann@xinux.de> writes:
> does this include the template1 database? So i have to vacuum the
> tempate1 database too on a regular  basis to avoid the rolling over of
> the transaction id?

Only if you're in the habit of modifying template1.

If you make occasional one-time changes to template1 (like, say,
installing plpgsql in it) you can do a "vacuum freeze" afterward
to make sure all is well; then you needn't include template1 in
your list of things to vacuum regularly.

            regards, tom lane

pgsql-general by date:

Previous
From: "SZŰCS Gábor"
Date:
Subject: Re: query visibility - trigger order - bug?
Next
From: Savita
Date:
Subject: Re: COPY COMMAND