From: Aditya Damle <aditya@skillnetinc.com>
To: pgsql-performance@postgresql.org
Subject: LIKE search with ending % not optimized in v8
Date: Wed, 22 Jun 2005 02:03:29 -0700 (PDT)
Message-ID: <20050622090329.34686.qmail@web32910.mail.mud.yahoo.com> (raw)
Hello. I believe in earlier versions, a query of the
form
select attrib from ttt where attrib like 'foo%' would
be able to take advantage of an index. I have seen
this in the past. Currently I am using v8.0.3. From
what I can see is that the execultion plan seems to
use a seq scan and to totally ignore the index. Is
this the case?
-Aditya
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: aditya@skillnetinc.com
Subject: Re: LIKE search with ending % not optimized in v8
In-Reply-To: <20050622090329.34686.qmail@web32910.mail.mud.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox