On Wed, 2003-10-29 at 19:57, Joshua D. Drake wrote:
> >Why are you running a vacuum full -- forgot to do a regular vacuum often
> >enough?
> >
> No because if we don't run a vacuum full on this (actually a couple of)
> machine
> then the machine slows down to a crawl over time. Vacuums are run every
> 4 or 5 hours
> and a vacuum full every night.
>
> I am obviously missing something and relying on past knowledge.
Yup.. Sounds like fsm is too low. Bump it up an order of magnitude and
vacuum hourly instead -- drop the FULL.
> >PostgreSQL also won't be answering queries if I unplug the
> >machine it is on, toss it into the back of a plane and fly it to another
> >data centre.
> >
> O.k. this was a ridiculous analogy.
Not really.. I see to do the data centre move more often than a VACUUM
FULL.