Alex,
> I read your article about indexing in postgres which unfortunately ends
> after the 2nd part. So I decided to ask you by email.
Yeah, yeah, I know. The completed version will probably become part of a
published book. We'll see.
> Is it somehow possible to create an index for the ILIK
Alex,
> mydb=# explain select filename from neighbors where filename ilike
> '%test%'; QUERY PLAN
> -
> Seq Scan on neighbors (cost=0.00..17449.64 rows=774 width=37)
> Filter: ((filename)::text ~~* '%test%'::text)
I just looked at