Horton

Re: spgist text_ops and LIKE

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Robert Haas <robertmhaas@gmail.com>
Cc: pgsql-hackers@postgresql.org, Teodor Sigaev <teodor@sigaev.ru>, Oleg Bartunov <oleg@sai.msu.su>
Date: 2012-02-02T03:57:48Z
Lists: pgsql-hackers 
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