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=i...@mail.gmail.com Branch ------ master Details ------- http://git.postgresql.org/pg/commitdiff/7f46eaf035440564e7dae3b03916735b92c83248 Modified Files -------------- doc/src/sgml/func.sgml | 26 ++++++++++++++++++ doc/src/sgml/gin.sgml | 4 ++- doc/src/sgml/ref/create_index.sgml | 4 +-- src/backend/access/gin/ginfast.c | 52 ++++++++++++++++++++++++++++++++++++ src/include/access/gin_private.h | 3 +++ src/include/catalog/catversion.h | 2 +- src/include/catalog/pg_proc.h | 2 ++ src/test/regress/expected/gin.out | 13 +++++++++ src/test/regress/sql/gin.sql | 6 +++++ 9 files changed, 108 insertions(+), 4 deletions(-) -- Sent via pgsql-committers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
