Re: Integrated autovacuum - Mailing list pgsql-hackers

From Joshua D. Drake
Subject Re: Integrated autovacuum
Date
Msg-id 42E7F790.2050905@commandprompt.com
Whole thread Raw
In response to Re: Integrated autovacuum  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Responses Re: Integrated autovacuum  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-hackers
Alvaro Herrera wrote:
> On Wed, Jul 27, 2005 at 12:53:40PM -0700, Joshua D. Drake wrote:
> 
> 
>>Just for clarification, will the new integrated autovacuum require that 
>>statistics are on?
> 
> 
> Yes.  Row-level stats too.

Great Thanks... Could I get a better explanation of the following:


#autovacuum_vacuum_scale_factor = 0.4   # fraction of rel size before vacuum
#autovacuum_analyze_scale_factor = 0.2  # fraction of rel size before 
analyze


Sincerely,

Joshua D. Drake

> 


-- 
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/


pgsql-hackers by date:

Previous
From: "Dave Page"
Date:
Subject: Re: --enable-thread-safety on Win32
Next
From: Martín Marqués
Date:
Subject: Re: Integrated autovacuum