On 2019-Jul-10, Robert Haas wrote: > On Tue, Jul 9, 2019 at 6:12 PM Alvaro Herrera <alvhe...@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
