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?
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
