Re: VACUUM/ANALYZE counting of in-doubt tuples

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: VACUUM/ANALYZE counting of in-doubt tuples
Дата
Msg-id 15089.1195669979@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: VACUUM/ANALYZE counting of in-doubt tuples  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Ответы Re: VACUUM/ANALYZE counting of in-doubt tuples  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-hackers
Alvaro Herrera <alvherre@alvh.no-ip.org> writes:
> Tom Lane wrote:
>> Should we attempt to adjust VACUUM's accounting as well, or leave it
>> for 8.4?  For that matter, should adjusting ANALYZE be left for 8.4?
>> Thoughts?

> Has this issue been a real problem?  If so, probably we should consider
> adjusting ANALYZE for 8.3 per your proposal.

I'm not sure.  Upthread, two or three people said they thought they'd
seen autovac launching vacuums against tables during bulk inserts.
However, that could only happen if there were already a reason to launch
an auto-analyze (which could misreport dead tuples and thus trigger a
subsequent auto-vacuum), and in typical bulk load situations I don't see
why that would be very likely to happen.

I'm fine with leaving the whole issue for 8.4.
        regards, tom lane


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

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Postgres 8.3 archive_command
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: pgsql: New versions of mingw have gettimeofday(), so add an autoconf