Hi,I am indexing a 100 million record table composed of varchar(255) as the field to be indexed. I have always seen that examples of pg_trgm are based on text type fields. Is this by any special reason?.
My computer is creating the index since 5 hours ago so I guess there must be something wrong...
Thanks :) ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend