|From:||Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>|
|To:||Andres Freund <andres(at)anarazel(dot)de>|
|Cc:||Pg Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, David Fetter <david(at)fetter(dot)org>, Robert Haas <robertmhaas(at)gmail(dot)com>, Rahila Syed <rahila(dot)syed(at)2ndquadrant(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Pavan Deolasee <pavan(dot)deolasee(at)gmail(dot)com>, Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>|
|Subject:||Re: monitoring CREATE INDEX [CONCURRENTLY]|
|Views:||Raw Message | Whole Thread | Download mbox | Resend email|
On 2019-Mar-25, Andres Freund wrote:
> I've not followed this thread at all, so I might just be out of my depth
> here. From my POV, a later patch in the yet-to-be-applied patchqueue
> moves the main part of cluster below the table AM (as there's enough low
> level details, e.g. dealing with HOT). Therefore I don't have a problem
> having heap's implementation interrogate the scan in a heap specific
> Is that the angle you were wondering about? If not, any chance to point
> out more precisely what to look at?
> Obviously out of pure laziness, I'd prefer this to go in after my move
> of index creation scans & cluster below tableam.h. But admittedly,
> managing my exhaustion isn't the the sole goal of the project....
Well, this is create index rather than cluster, but yes this conflicts
pretty heavily with patch 0008 in your v21 at
20190324031630(dot)nt7numguo5ojq6uv(at)alap3(dot)anarazel(dot)de(dot) I wonder if I should
rather push and help merge your 0008, or wait until you push and deal
with it afterwards. I'd rather do the former, I think.
Anyway I was thinking about the conceptual angle -- the progress
monitoring stuff is doing block-based reporting. I think even if we get
a non-block-based heap, we can still report the number of physical
blocks already processed by the scan, which is what the index build
monitoring is interested in showing the user.
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
|Next Message||Alvaro Herrera||2019-03-26 02:42:53||Re: psql display of foreign keys|
|Previous Message||Michael Paquier||2019-03-26 02:35:10||Re: REINDEX CONCURRENTLY 2.0|