Postgres Pro
Downloads
Home   >   mailing lists

Re: Optimizer Question/Suggestion - numbers after - Mailing list pgsql-hackers

From Doug McNaught
Subject Re: Optimizer Question/Suggestion - numbers after
Date
Msg-id m3iszg59dy.fsf@varsoon.wireboard.com
Whole thread Raw
In response to Re: Optimizer Question/Suggestion - numbers after  (Philip Warner <pjw@rhyme.com.au>)
List pgsql-hackers
Tree view 
Philip Warner <pjw@rhyme.com.au> writes:

> At 07:39 PM 2/11/2002 +1100, Philip Warner wrote:

> The latter time is actually quote good; when the machine is more
> heavily loaded it goes up to 10000ms.
> 
> We currently vacuum/analyze daily, and analyze hourly.

Why not vacuum hourly (regular non-blocking vacuum, not FULL)?

-Doug

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: "Cache lookup failed for relation 16905" ??
Next
From: Tom Lane
Date:
Subject: Re: Optimizer Question/Suggestion