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(-)
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 |