Indexes with LIKE

From: "Julian Scarfe" <julian(dot)scarfe(at)ntlworld(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Indexes with LIKE
Date: 2002-07-13 09:53:23
Message-ID: 000901c22a53$206e0ad0$0500a8c0@Wilbur
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I've noticed a difference in behaviour between a server running version 6.x
and one running 7.2.1 in use of indexes with LIKE.

With an index on foo,

WHERE foo LIKE 'bar%'

uses the index (as I would expect it to) on the 6.x box, but uses a
sequential scan (really slow) on the 7.2.1 box.
It's possible that I've set (or failed to set) a run-time parameter that
controls the behaviour, but I don't know what that might be. ANALYZEing the
table doesn't modify the behaviour.

I can't find any mention of this in the documentation -- any pointers would
be appreciated.

If the above doesn't ring any bells, I'll put together an example.

Many thanks

Julian Scarfe

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 2002-07-13 14:50:59 Re: pg_restore cannot restore index
Previous Message Bruce Momjian 2002-07-13 04:27:33 Re: Query kill