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

Re: Search string without tsearch

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: A(dot)Burbello <burbello3000(at)yahoo(dot)com(dot)br>
Cc: "Postgres Adm List" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Search string without tsearch
Date: 2008-01-28 18:41:12
Message-ID: dcc563d10801281041p1aaccf69s5f571b9eefa47460@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Jan 28, 2008 11:38 AM, A.Burbello <burbello3000(at)yahoo(dot)com(dot)br> wrote:
> Hi people,
>
> I would like to some suggestion to search person name
> in a table that has more than 150 milions of rows ...
>
> e.g ... name like 'JOHN%SMITH';
>
> I know there is contrib Tsearch, but I can't for
> political reasons.
> Is there any way to do with good performance???

Would pointing out to the PHBs that tsearch was integrated into pgsql
with v8.3 help convince them to stop being reactionary idiots?

In response to

pgsql-admin by date

Next:From: dx k9Date: 2008-01-28 20:37:58
Subject: Zen and art if WAL and dump file mainteance
Previous:From: A.BurbelloDate: 2008-01-28 17:38:15
Subject: Search string without tsearch

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