Postgres Pro
Downloads
Home   >   mailing lists

Re: spgist text_ops and LIKE - Mailing list pgsql-hackers

From Tom Lane
Subject Re: spgist text_ops and LIKE
Date
Msg-id 15586.1328155068@sss.pgh.pa.us
Whole thread Raw
In response to spgist text_ops and LIKE  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: spgist text_ops and LIKE  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Tree view 
Robert Haas <robertmhaas@gmail.com> writes:
> Is spgist intended to support prefix searches with LIKE?

Too lazy to look at the code right now, but I think indxpath.c contains
hardwired assumptions that LIKE prefix optimizations are only possible
with btree indexes.  Possibly it would be worth relaxing that.  (The
whole "special index operator" mechanism is undesirably special-purpose,
but I currently have no ideas about how to make it more flexible.)
        regards, tom lane

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: feature request - datum_compute_size and datum write_should be public
Next
From: Tom Lane
Date:
Subject: Re: heap_tuple_needs_freeze false positive