Re: docfix - DELETE doesn't affect auto-analyze

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: docfix - DELETE doesn't affect auto-analyze
Дата
Msg-id 6227.1184730905@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: docfix - DELETE doesn't affect auto-analyze  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: docfix - DELETE doesn't affect auto-analyze
Re: docfix - DELETE doesn't affect auto-analyze
Список pgsql-patches
Bruce Momjian <bruce@momjian.us> writes:
>> -    is compared to the total number of tuples inserted, updated, or deleted
>> +    is compared to the total number of tuples inserted or updated

As best I can tell, this description is even further away from the
actual CVS HEAD behavior than the previous one.  The code is comparing
against

        anltuples = tabentry->n_live_tuples + tabentry->n_dead_tuples -
            tabentry->last_anl_tuples;

and deletions surely increase n_dead_tuples.

            regards, tom lane

В списке pgsql-patches по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: execl() sentinel
Следующее
От: ITAGAKI Takahiro
Дата:
Сообщение: Re: docfix - DELETE doesn't affect auto-analyze