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-
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? |