Re: Auto ANALYZE criteria

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Joe Miller <joe(dot)d(dot)miller(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Auto ANALYZE criteria
Date: 2010-09-21 20:44:20
Message-ID: 8963.1285101860@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Joe Miller <joe(dot)d(dot)miller(at)gmail(dot)com> writes:
> I was looking at the autovacuum documentation:
> http://www.postgresql.org/docs/9.0/interactive/routine-vacuuming.html#AUTOVACUUM

> For analyze, a similar condition is used: the threshold, defined as:
> analyze threshold = analyze base threshold + analyze scale factor *
> number of tuples
> is compared to the total number of tuples inserted or updated since
> the last ANALYZE.

> I guess that should be updated to read "insert, updated or deleted".

Mph. We caught the other places where the docs explain what the analyze
threshold is, but missed that one. Fixed, thanks for pointing it out.

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2010-09-21 23:24:47 Re: Query much faster with enable_seqscan=0
Previous Message Ozer, Pam 2010-09-21 20:04:01 Re: Using Between