Skip site navigation (1) Skip section navigation (2)

LIKE search with ending % not optimized in v8

From: Aditya Damle <aditya(at)skillnetinc(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: LIKE search with ending % not optimized in v8
Date: 2005-06-22 09:03:29
Message-ID: 20050622090329.34686.qmail@web32910.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-performance
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


Responses

pgsql-performance by date

Next:From: Kjell Tore FossbakkDate: 2005-06-22 09:10:42
Subject: Re: Querying 19million records very slowly
Previous:From: Michael GlaesemannDate: 2005-06-22 08:55:35
Subject: Re: Querying 19million records very slowly

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group