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

pgsql: Refactor GIN's handling of duplicate search entries.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Refactor GIN's handling of duplicate search entries.
Date: 2011-01-08 19:48:48
Message-ID: E1PbemO-0006Es-K8@gemulon.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Refactor GIN's handling of duplicate search entries.

The original coding could combine duplicate entries only when they
originated from the same qual condition.  In particular it could not
combine cases where multiple qual conditions all give rise to full-index
scan requests, which is an expensive case well worth optimizing.  Refactor
so that duplicates are recognized across all the quals.

Branch
------
master

Details
-------
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=56a57473a999b0497e63bde3e303beda5a3c0ff3

Modified Files
--------------
src/backend/access/gin/ginget.c  |  419 +++++++++++++++++++-------------------
src/backend/access/gin/ginscan.c |  294 +++++++++++++++------------
src/include/access/gin_private.h |   52 +++--
3 files changed, 402 insertions(+), 363 deletions(-)

pgsql-committers by date

Next:From: Tom LaneDate: 2011-01-08 21:08:23
Subject: pgsql: Remove pg_am.amindexnulls.
Previous:From: Bruce MomjianDate: 2011-01-08 18:45:25
Subject: pgsql: In pg_upgrade,remove functions that did sequential array scans

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