pgsql: Microvacuum for GIST - Mailing list pgsql-committers

From Teodor Sigaev
Subject pgsql: Microvacuum for GIST
Date
Msg-id E1ZZhXW-0000wO-GZ@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Microvacuum for GIST

Mark index tuple as dead if it's pointed by kill_prior_tuple during
ordinary (search) scan and remove it during insert process if there is no
enough space for new tuple to insert. This improves select performance
because index will not return tuple marked as dead and improves insert
performance because it reduces number of page split.

Anastasia Lubennikova <a.lubennikova@postgrespro.ru> with
 minor editorialization by me

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/013ebc0a7b7ea9c1b1ab7a3d4dd75ea121ea8ba7

Modified Files
--------------
src/backend/access/gist/gist.c     |   82 +++++++++++++++++++++
src/backend/access/gist/gistget.c  |  137 +++++++++++++++++++++++++++++++++++-
src/backend/access/gist/gistscan.c |    5 ++
src/include/access/gist.h          |    9 ++-
src/include/access/gist_private.h  |   11 ++-
5 files changed, 241 insertions(+), 3 deletions(-)


pgsql-committers by date:

Previous
From: Fujii Masao
Date:
Subject: pgsql: Remove files signaling a standby promotion request at postmaster
Next
From: Teodor Sigaev
Date:
Subject: pgsql: Fix oversight in 013ebc0a7b7ea9c1b1ab7a3d4dd75ea121ea8ba7 commit