Skip site navigation (1) Skip section navigation (2)

pgsql: Back-patch recent fixes for gistchoose andgistRelocateBuildBuff

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Back-patch recent fixes for gistchoose andgistRelocateBuildBuff
Date: 2012-08-31 03:49:03
Message-ID: E1T7IEB-0006PN-7g@gemulon.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Back-patch recent fixes for gistchoose and gistRelocateBuildBuffersOnSplit.

This back-ports commits c8ba697a4bdb934f0c51424c654e8db6133ea255 and
e5db11c5582b469c04a11f217a0f32c827da5dd7, which fix one definite and one
speculative bug in gistchoose, and make the code a lot more intelligible as
well.  In 9.2 only, this also affects the largely-copied-and-pasted logic
in gistRelocateBuildBuffersOnSplit.

The impact of the bugs was that the functions might make poor decisions
as to which index tree branch to push a new entry down into, resulting in
GiST index bloat and poor performance.  The fixes rectify these decisions
for future insertions, but a REINDEX would be needed to clean up any
existing index bloat.

Alexander Korotkov, Robert Haas, Tom Lane

Branch
------
REL9_1_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/6707dd48cdfcc95934a89df5ad4c4c2ecf0e5225

Modified Files
--------------
src/backend/access/gist/gistutil.c |   98 ++++++++++++++++++++++++++---------
1 files changed, 73 insertions(+), 25 deletions(-)

pgsql-committers by date

Next:From: Heikki LinnakangasDate: 2012-08-31 08:30:38
Subject: pgsql: Fix typos in README.
Previous:From: Tom LaneDate: 2012-08-31 02:53:36
Subject: pgsql: Improve coding of gistchoose andgistRelocateBuildBuffersOnSplit

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group