Ah.., no we're not vacuuming template0 or 1.
I didn't realise that the transaction ID would be stored here - I assumed that they'd be in our database.
Do I need to need to (plain) vacuum, or vacuum full these template0 and template1? And is this something that can be done once a week rather than every night (like our main database)?
Ah! Found the section of the manuals - see "Routine Database Maintenance Tasks" for details.
AFAIK it's a simple vacuum and once a week is more than enough. The manual recommends once every 500million transactions, though you can leave it longer.
-- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
