database vacuum

[NH Lau]

Dear List,

I am using postgresql 7.2.1. I would like to know
whether we should vacuum the template1 and template0
database as well, in addition to the normal database
we created.

Your reply is very much appreciated.

Regards
Lau NH



__________________________________
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.
http://promotions.yahoo.com/new_mail

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ***@postgresql.org)

[Tom Lane]

Post by NH Lau
I would like to know
whether we should vacuum the template1 and template0
database as well, in addition to the normal database
we created.

template0 no --- in fact you wouldn't even be able to connect to it to
do so (and I do not recommend overriding the check that prevents that).

template1 yes. You could skip this if you know that template1 has never
been modified since it was frozen ... but why assume that?

The vacuumdb script gets this right btw.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ***@postgresql.org so that your
message can get through to the mailing list cleanly