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

pgsql: Rewrite GiST support code for rangetypes.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Rewrite GiST support code for rangetypes.
Date: 2012-03-05 03:50:18
Message-ID: E1S4OwE-0000Yr-14@gemulon.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Rewrite GiST support code for rangetypes.

This patch installs significantly smarter penalty and picksplit functions
for ranges, making GiST indexes for them smaller and faster to search.

There is no on-disk format change, so no catversion bump, but you'd need
to REINDEX to get the benefits for any existing index.

Alexander Korotkov, reviewed by Jeff Davis

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/80da9e68fdd70b796b3a7de3821589513596c0f7

Modified Files
--------------
src/backend/utils/adt/rangetypes_gist.c | 1293 ++++++++++++++++++++++++++-----
1 files changed, 1102 insertions(+), 191 deletions(-)

pgsql-committers by date

Next:From: Peter EisentrautDate: 2012-03-05 18:20:32
Subject: pgsql: Add isolation test to check-world and installcheck-world
Previous:From: Tom LaneDate: 2012-03-04 21:03:47
Subject: pgsql: Remove useless "rough estimate" path frommcelem_array_contained

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