John Sidney-Woollett wrote:
> 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