Re: Query results caching?

Dann Corbit wrote:
>
> If I have a 4 million row table, with long rows and big varchar columns
> and I run a query on a column like this:
>
>     SELECT * FROM inventory WHERE product LIKE '%Table%'
>
> It isn't going to be fast on any system with any database.

Hypothetically it seems one could theoretically use some sort
of GIST index not unlike the contrib/trigram stuff to speed
up like clauses like that.   If so, I wonder if down the road
that could be a nice competitive advantage over systems with
less flexible index systems.  Is that a possible TODO?