Re: progress report for ANALYZE - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: progress report for ANALYZE
Date
Msg-id 20190710132628.GA26281@alvherre.pgsql
Whole thread Raw
In response to Re: progress report for ANALYZE  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: progress report for ANALYZE  (Robert Haas <robertmhaas@gmail.com>)
List 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 by date:

Previous
From: Robert Haas
Date:
Subject: Re: progress report for ANALYZE
Next
From: Magnus Hagander
Date:
Subject: Re: global / super barriers (for checksums)