Message-ID: <46546335.5000109@finestmedia.ee>
Date: Wed, 23 May 2007 18:52:21 +0300
From: Rigmor Ukuhe <rigmor.ukuhe@finestmedia.ee>
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
MIME-Version: 1.0
Cc: pgsql-performance@postgresql.org
Subject: Re: LIKE search and performance
References: <009501c79d4c$445428f0$0b00a8c0@mpsro.dom>
In-Reply-To: <009501c79d4c$445428f0$0b00a8c0@mpsro.dom>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Andy wrote:
> Hi,
>  
> I have a table with varchar and text columns, and I have to search 
> through these text in the whole table.
>  
> An example would be:
> SELECT * FROM table
>                              WHERE name like '%john%' or street like '%srt%'
>  
> Anyway, the query planner always does seq scan on the whole table and 
> that takes some time. How can this be optimized or made in another way 
> to be faster?

Use tsearch2 (http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/) for full text indexing.

Rigmor

>  
> I tried to make indexes on the columns but no success.
>  
> PG 8.2
>  
> Regards,
> Andy.