How and for what to use SP-GIST?

From: Christian Hammers <ch(at)lathspell(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: How and for what to use SP-GIST?
Date: 2012-11-24 20:14:21
Message-ID: 20121124211421.60e67b43@james.intern
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello

The release notes of PostgreSQL 9.2 praise "SP-GIST" as a major feature
but I cannot find any information on how to actually use it.

The main documentation seems unusual low level and the examples chapter
just refers to the source code. The only examples I can find there are
the regression tests.

In those I stumbled across the "~>=~" operator. How does it differ
from the normal ">="? (kind of hard to google for this string :))

SP-GIST should be good at "suffix search", I read. What exactly is
meant here? I assume its not suffix as in "LIKE '%foo'".

I'm interested because I heavily use the prefix_range extension for
phone number searching. Could I somehow benefit from a SP-GIST suffix
index (maybe by reversing my numbers)?

thanks for any comments!

bye,

-christian-

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Janes 2012-11-24 20:25:30 Re: Restore postgres to specific time
Previous Message Bruce Momjian 2012-11-24 17:49:13 Re: 9.1 to 9.2 requires a dump/reload?