pgsql: Microvacuum for GIST

From: Teodor Sigaev <teodor(at)sigaev(dot)ru>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Microvacuum for GIST
Date: 2015-09-09 15:44:02
Message-ID: E1ZZhXW-0000wO-GZ@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)lubennikova(at)postgrespro(dot)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(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Teodor Sigaev 2015-09-09 16:22:58 pgsql: Fix oversight in 013ebc0a7b7ea9c1b1ab7a3d4dd75ea121ea8ba7 commit
Previous Message Fujii Masao 2015-09-09 14:06:44 pgsql: Remove files signaling a standby promotion request at postmaster