]> granicus.if.org Git - postgresql/commit
Add gin_clean_pending_list function to clean up GIN pending list
authorFujii Masao <fujii@postgresql.org>
Thu, 28 Jan 2016 03:57:52 +0000 (12:57 +0900)
committerFujii Masao <fujii@postgresql.org>
Thu, 28 Jan 2016 03:57:52 +0000 (12:57 +0900)
commit7f46eaf035440564e7dae3b03916735b92c83248
treec8eeeea61e1e5046a1ed7edd737610dab862c11a
parenteaf7b1f6432480e93d8c6824fbd503761a1c1a4f
Add gin_clean_pending_list function to clean up GIN pending list

This function cleans up the pending list of the GIN index by
moving entries in it to the main GIN data structure in bulk.
It returns the number of pages cleaned up from the pending list.

This function is useful, for example, when the pending list
needs to be cleaned up *quickly* to improve the performance of
the search using GIN index. VACUUM can do the same thing, too,
but it may take days to run on a large table.

Jeff Janes,
reviewed by Julien Rouhaud, Jaime Casanova, Alvaro Herrera and me.

Discussion: CAMkU=1x8zFkpfnozXyt40zmR3Ub_kHu58LtRmwHUKRgQss7=iQ@mail.gmail.com
doc/src/sgml/func.sgml
doc/src/sgml/gin.sgml
doc/src/sgml/ref/create_index.sgml
src/backend/access/gin/ginfast.c
src/include/access/gin_private.h
src/include/catalog/catversion.h
src/include/catalog/pg_proc.h
src/test/regress/expected/gin.out
src/test/regress/sql/gin.sql