pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
database vacuum
2+ messages / 2 participants
[nested] [flat]

* database vacuum
@ 2004-09-07 03:33 NH Lau <nhlau2k@yahoo.com>
  2004-09-07 03:46 ` Re: database vacuum Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 2+ messages in thread

From: NH Lau @ 2004-09-07 03:33 UTC (permalink / raw)
  To: pgsql-admin

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 



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: database vacuum
  2004-09-07 03:33 database vacuum NH Lau <nhlau2k@yahoo.com>
@ 2004-09-07 03:46 ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2004-09-07 03:46 UTC (permalink / raw)
  To: NH Lau <nhlau2k@yahoo.com>; +Cc: pgsql-admin

NH Lau <nhlau2k@yahoo.com> writes:
> 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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2004-09-07 03:46 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-09-07 03:33 database vacuum NH Lau <nhlau2k@yahoo.com>
2004-09-07 03:46 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox