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
> No because if we don't run a vacuum full on this (actually a couple of)
> 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
In response to
pgsql-advocacy by date
|Next:||From: Jussi Mikkola||Date: 2003-10-30 01:19:49|
|Subject: Re: Press Release and eRServer|
|Previous:||From: Josh Berkus||Date: 2003-10-30 00:58:05|
|Subject: Re: Press Release|