Hi,
this is with 9.2.4_PGDG / FC18 / 64bit upgraded from 9.1.8 via
dump/restore, settings kept for the most part.
Table has 1.5M records, the varchar(100) field in question has a *
varchar_ops* and a *varchar_pattern_ops* btree index.
3 Cases:
- "MYFIELD" like 'BLA BLA *%*': *OK, about 7 mse
On 7 April 2013 15:52, Kevin Grittner wrote:
> David Johnston wrote:
>
> > varchar(100)
>
> > The other option to index words via the full-text search capabilities.
>
> Or for columns this short, a similarity search on a trigram index.
>
> http://www.postgresql.org/docs/current/interactive/pgtr
