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

git projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 4c83e59) | patch
Ignore BRIN indexes when checking for HOT udpates
2021年11月30日 18:15:14 +0000 (19:15 +0100)
2021年11月30日 19:04:38 +0000 (20:04 +0100)
commit 5753d4ee320b3f6fb2ff734667a1ce1d9d8615a1
Ignore BRIN indexes when checking for HOT udpates

When determining whether an index update may be skipped by using HOT, we
can ignore attributes indexed only by BRIN indexes. There are no index
pointers to individual tuples in BRIN, and the page range summary will
be updated anyway as it relies on visibility info.

This also removes rd_indexattr list, and replaces it with rd_attrsvalid
flag. The list was not used anywhere, and a simple flag is sufficient.

Patch by Josef Simanek, various fixes and improvements by me.

Author: Josef Simanek
Reviewed-by: Tomas Vondra, Alvaro Herrera
Discussion: https://postgr.es/m/CAFp7QwpMRGcDAQumN7onN9HjrJ3u4X3ZRXdGFT0K5G2JWvnbWg%40mail.gmail.com
15 files changed:
doc/src/sgml/indexam.sgml diff | blob | blame | history
src/backend/access/brin/brin.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/hash/hash.c diff | blob | blame | history
src/backend/access/heap/heapam.c diff | blob | blame | history
src/backend/access/nbtree/nbtree.c diff | blob | blame | history
src/backend/access/spgist/spgutils.c diff | blob | blame | history
src/backend/utils/cache/relcache.c diff | blob | blame | history
src/include/access/amapi.h diff | blob | blame | history
src/include/utils/rel.h diff | blob | blame | history
src/include/utils/relcache.h diff | blob | blame | history
src/test/modules/dummy_index_am/dummy_index_am.c diff | blob | blame | history
src/test/regress/expected/brin.out diff | blob | blame | history
src/test/regress/sql/brin.sql diff | blob | blame | history
This is the main PostgreSQL git repository.
RSS Atom

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