Vacuum strategy for a frequently rebooted system? - Mailing list pgsql-novice

From Ron Mayer
Subject Vacuum strategy for a frequently rebooted system?
Date
Msg-id ctroj7$31b7$1@news.hub.org
Whole thread Raw
List pgsql-novice
I have a very frequently rebooted system (salesguys' laptops), with
a fairly high insert/delete activity (few hundred thousand rows
during a demo).

Anything I should keep in mind in setting up vacuum scripts for
such a system? For example...

... does it matter if I vacuum at startup or at shutdown?  I
     seem to remember an earlier version wanted me to vacuum
     at startup; but don't know if this is still true?

... would the autovacuum stuff with a nice vacuum_delay
     setting work well in this case?

anything else I should watch for?

pgsql-novice by date:

Previous
From: Jeremiah Knoche
Date:
Subject: Batch Insert tables
Next
From: "John Hansen"
Date:
Subject: Re: [HACKERS] Last ID Problem