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
