Re: 8.0.0beta3 vacuum analyze - Mailing list pgsql-general

From Neil Conway
Subject Re: 8.0.0beta3 vacuum analyze
Date
Msg-id 1098081806.22986.309.camel@localhost.localdomain
Whole thread Raw
In response to 8.0.0beta3 vacuum analyze  ("Ed L." <pgsql@bluepolka.net>)
List pgsql-general
On Mon, 2004-10-18 at 14:49, Ed L. wrote:
> I *think* I'm seeing "vacuum analyze" queries launched automatically on an
> 8.0.0beta3 (unless I have a rogue autovac running that I haven't spotted).
> Is this something new in 8.0 and to be expected?

No.

> #vacuum_cost_delay = 0        # 0-1000 milliseconds
> #vacuum_cost_page_hit = 1       # 0-10000 credits
> #vacuum_cost_page_miss = 10     # 0-10000 credits
> #vacuum_cost_page_dirty = 20    # 0-10000 credits
> #vacuum_cost_limit = 200        # 0-10000 credits

Vacuum cost delay affects the way that VACUUM behaves, not the frequency
with which it is executed.

-Neil



pgsql-general by date:

Previous
From: Kris Jurka
Date:
Subject: Re: create view problem
Next
From: John DeSoi
Date:
Subject: Re: OS X Install