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/
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
