Vacuum strategy for a frequently rebooted system?

From: Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Vacuum strategy for a frequently rebooted system?
Date: 2005-02-02 23:50:35
Message-ID: ctroj7$31b7$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Fuhr 2005-02-03 01:12:04 Re: How to "COPY schema1.table TO schema2.table" ?
Previous Message Andrew Hammond 2005-02-02 22:04:52 Re: grant all the database object automatically