Skip site navigation (1) Skip section navigation (2)

Autoanalyze settings with zero scale factor

From: "Jeremy Haile" <jhaile(at)fastmail(dot)fm>
To: pgsql-performance(at)postgresql(dot)org
Subject: Autoanalyze settings with zero scale factor
Date: 2007-01-18 18:37:54
Message-ID: 1169145474.20103.1169962769@webmail.messagingengine.com (view raw or flat)
Thread:
Lists: pgsql-performance
Some of my very large tables (10 million rows) need to be analyzed by
autovacuum on a frequent basis.  Rather than specifying this as a
percentage of table size + base threshold, I wanted to specify it as an
explicit number of rows.

I changed the table-specific settings so that the ANALYZE base threshold
was 5000 and the ANALYZE scale factor is 0.  According to the documented
formula: analyze threshold = analyze base threshold + analyze scale
factor * number of tuples, I assumed that this would cause the table to
be analyzed everytime 5000 tuples were inserted/updated/deleted.

However, the tables have been updated with tens of thousands of inserts
and the table has still not been analyzed (according to
pg_stat_user_tables).  Does a scale factor of 0 cause the table to never
be analyzed?  What am I doing wrong?

I'm using PG 8.2.1.

Thanks,
Jeremy Haile

Responses

pgsql-performance by date

Next:From: Matthew T. O'ConnorDate: 2007-01-18 19:20:11
Subject: Re: Autoanalyze settings with zero scale factor
Previous:From: Jeremy HaileDate: 2007-01-18 17:28:27
Subject: Re: Configuration Advice

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group