git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 4d0e994) | patch
Report progress of CREATE INDEX operations
Tue, 2 Apr 2019 18:18:08 +0000 (15:18 -0300)
Tue, 2 Apr 2019 18:18:08 +0000 (15:18 -0300)
commit ab0dfc961b6a821f23d9c40c723d11380ce195a6
Report progress of CREATE INDEX operations

This uses the progress reporting infrastructure added by c16dc1aca5e0,
adding support for CREATE INDEX and CREATE INDEX CONCURRENTLY.

There are two pieces to this: one is index-AM-agnostic, and the other is
AM-specific. The latter is fairly elaborate for btrees, including
reportage for parallel index builds and the separate phases that btree
index creation uses; other index AMs, which are much simpler in their
building procedures, have simplistic reporting only, but that seems
sufficient, at least for non-concurrent builds.

The index-AM-agnostic part is fairly complete, providing insight into
the CONCURRENTLY wait phases as well as block-based progress during the
index validation table scan. (The index validation index scan requires
patching each AM, which has not been included here.)

Reviewers: Rahila Syed, Pavan Deolasee, Tatsuro Yamada
Discussion: https://postgr.es/m/20181220220022.mg63bhk26zdpvmcj@alvherre.pgsql
37 files changed:
contrib/amcheck/verify_nbtree.c diff | blob | blame | history
contrib/bloom/blinsert.c diff | blob | blame | history
contrib/bloom/blutils.c diff | blob | blame | history
doc/src/sgml/indexam.sgml diff | blob | blame | history
doc/src/sgml/monitoring.sgml diff | blob | blame | history
src/backend/access/brin/brin.c diff | blob | blame | history
src/backend/access/gin/gininsert.c diff | blob | blame | history
src/backend/access/gin/ginutil.c diff | blob | blame | history
src/backend/access/gist/gist.c diff | blob | blame | history
src/backend/access/gist/gistbuild.c diff | blob | blame | history
src/backend/access/hash/hash.c diff | blob | blame | history
src/backend/access/hash/hashsort.c diff | blob | blame | history
src/backend/access/heap/heapam_handler.c diff | blob | blame | history
src/backend/access/nbtree/nbtree.c diff | blob | blame | history
src/backend/access/nbtree/nbtsort.c diff | blob | blame | history
src/backend/access/nbtree/nbtutils.c diff | blob | blame | history
src/backend/access/spgist/spginsert.c diff | blob | blame | history
src/backend/access/spgist/spgutils.c diff | blob | blame | history
src/backend/catalog/index.c diff | blob | blame | history
src/backend/catalog/system_views.sql diff | blob | blame | history
src/backend/commands/indexcmds.c diff | blob | blame | history
src/backend/storage/ipc/standby.c diff | blob | blame | history
src/backend/storage/lmgr/lmgr.c diff | blob | blame | history
src/backend/storage/lmgr/lock.c diff | blob | blame | history
src/backend/utils/adt/amutils.c diff | blob | blame | history
src/backend/utils/adt/pgstatfuncs.c diff | blob | blame | history
src/include/access/amapi.h diff | blob | blame | history
src/include/access/genam.h diff | blob | blame | history
src/include/access/nbtree.h diff | blob | blame | history
src/include/access/tableam.h diff | blob | blame | history
src/include/catalog/catversion.h diff | blob | blame | history
src/include/catalog/pg_proc.dat diff | blob | blame | history
src/include/commands/progress.h diff | blob | blame | history
src/include/pgstat.h diff | blob | blame | history
src/include/storage/lmgr.h diff | blob | blame | history
src/include/storage/lock.h diff | blob | blame | history
src/test/regress/expected/rules.out diff | blob | blame | history
This is the main PostgreSQL git repository.
RSS Atom

AltStyle によって変換されたページ (->オリジナル) /