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

pgsql: Optimize SP-GiST insertions.

From: Heikki Linnakangas <heikki(dot)linnakangas(at)iki(dot)fi>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Optimize SP-GiST insertions.
Date: 2012-08-29 06:22:35
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-committers
Optimize SP-GiST insertions.

This includes two micro-optimizations to the tight inner loop in descending
the SP-GiST tree: 1. avoid an extra function call to index_getprocinfo when
calling user-defined choose function, and 2. avoid a useless palloc+pfree
when node labels are not used.



Modified Files
src/backend/access/spgist/spgdoinsert.c |   10 +++++++-
src/backend/access/spgist/spgutils.c    |   33 +++++++++++++++++-------------
2 files changed, 27 insertions(+), 16 deletions(-)

pgsql-committers by date

Next:From: Bruce MomjianDate: 2012-08-29 21:05:40
Subject: pgsql: Report file as empty if it is empty, rather than
Previous:From: Alvaro HerreraDate: 2012-08-29 03:51:24
Subject: pgsql: Fix assorted compilation failures in contrib

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