Re: LIKE search and performance - Mailing list pgsql-performance

From Rigmor Ukuhe
Subject Re: LIKE search and performance
Date
Msg-id 46546335.5000109@finestmedia.ee
Whole thread Raw
In response to LIKE search and performance  ("Andy" <frum@ar-sd.net>)
Responses Re: LIKE search and performance  ("Andy" <frum@ar-sd.net>)
List pgsql-performance
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.




pgsql-performance by date:

Previous
From: "Alexander Staubo"
Date:
Subject: Re: LIKE search and performance
Next
From: "Y Sidhu"
Date:
Subject: max_fsm_pages, shared_buffers and checkpoint_segments