Re: Auto ANALYZE criteria
| От | Tom Lane |
|---|---|
| Тема | Re: Auto ANALYZE criteria |
| Дата | |
| Msg-id | 8963.1285101860@sss.pgh.pa.us обсуждение |
| Ответ на | Re: Auto ANALYZE criteria (Joe Miller <joe.d.miller@gmail.com>) |
| Ответы |
Re: Auto ANALYZE criteria
|
| Список | pgsql-performance |
Joe Miller <joe.d.miller@gmail.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
В списке pgsql-performance по дате отправления: