Re: [GENERAL] Postgres doesn't use indexes for prefix matching?

[wespvp]

Your message from 7/2 just showed up today.

> db=# explain analyze SELECT id FROM object WHERE name ~ '^Jon V';

I use leading substring indexing all the time.  Try:

  SELECT id FROM object WHERE name like 'Jon V%';

Wes


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend