Efficient String searching

From: Robert(dot)Farrugia(at)go(dot)com(dot)mt
To: pgsql-admin(at)postgresql(dot)org
Subject: Efficient String searching
Date: 2001-09-25 06:00:55
Message-ID: OF2CFDB502.49ABF160-ONC1256AD2.0020E35E@go.com.mt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I have the following problem. When doing string searches using the ilike
command, no indexes are being used. This is giving performance problems,
whereas it takes longer to sequentially search the whole table. Am i
missing something about searching for strings ? Are there any efficient
methods than using regular expressions or like ?

Thanks
Robert

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ales Vojacek 2001-09-25 16:32:12 Create DB on postgresql 7.1.3 on cygwin
Previous Message david 2001-09-24 01:41:45 pg_dump, ERROR: More than one tuple returned