Postgres Pro
Downloads
Home   >   mailing lists

Re: SELECT speed with LIKE - Mailing list pgsql-general

From Frank Bax
Subject Re: SELECT speed with LIKE
Date
Msg-id 3.0.6.32.20000402192403.0096b5f0@execulink.com
Whole thread Raw
In response to SELECT speed with LIKE  (JB <jimbag@kw.igs.net>)
List pgsql-general
Tree view 
At 01:33 PM 4/01/00 -0500, you wrote:
>The table has a field called 'stname char(17)' which is indexed. The
>query is "SELECT * FROM data WHERE stname LIKE 'MAIN%'". I'm running on
>Redhat 6.1, 128MB ram, 40GB, P350. The actual index file is 4 MB.

I haven't tried it, but didn't someone mention a few weeks ago that  "WHERE
stname ~ '^MAIN'"  would produce the same results faster?

pgsql-general by date:

Previous
From: brew@theMode.com
Date:
Subject: Re: SELECT speed with LIKE
Next
From: Jeff MacDonald
Date:
Subject: sql92