>>> On Fri, Dec 14, 2007 at 1:42 AM, in message <29185.1197618162@xxxxxxxxxxxxx>, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > My feeling is that vacuum's purpose in life is to offload maintenance > cycles from foreground queries, so we should be happy to have it setting > all the hint bits. Absolutely. > If Kevin doesn't like the resultant I/O load then he > should use the vacuum_cost_delay parameters to dial down vacuum speed. It's not that I don't like it -- I'm often called upon to diagnose issues, and understanding the dynamics of things like this helps me interpret what I'm seeing. No complaint here. -Kevin ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq