Re: progress report for ANALYZE

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: progress report for ANALYZE
Дата
Msg-id 20190710132628.GA26281@alvherre.pgsql
обсуждение исходный текст
Ответ на Re: progress report for ANALYZE  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: progress report for ANALYZE  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
On 2019-Jul-10, Robert Haas wrote:

> On Tue, Jul 9, 2019 at 6:12 PM Alvaro Herrera <alvherre@2ndquadrant.com> wrote:
> > Hmm, ok.  In CREATE INDEX, we use the block counters multiple times.
> 
> Why do we do that?

Because we scan the table first, then the index, then the table again
(last two for the validation phase of CIC).  We count "block numbers"
separately for each of those, and keep those counters in the same pair
of columns.  I think we also do that for tuple counters in one case.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: progress report for ANALYZE
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: global / super barriers (for checksums)