| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | nolan(at)celery(dot)tssi(dot)com |
| Cc: | pgsql general list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: MySQL/PG search times |
| Date: | 2003-06-23 18:32:38 |
| Message-ID: | 200306231832.h5NIWci23968@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-advocacy pgsql-docs pgsql-general |
See the FAQ item about index usage. You have to anchor the start only.
---------------------------------------------------------------------------
nolan(at)celery(dot)tssi(dot)com wrote:
> > We require ~* syntax for that, or upper()/lower().
>
> Slowly the light dawns!
>
> If I anchor a ~ search on both ends, it is the same search as =.
>
> Duh!
>
> I converted the prototype over to use ~ and it is running much faster.
> I'll try to do some detailed timings against MySQL tonight.
> --
> Mike Nolan
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2003-06-23 18:49:14 | Re: [GENERAL] interesting PHP/MySQL thread |
| Previous Message | nolan | 2003-06-23 18:11:19 | MySQL/PG search times |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Erik Price | 2003-06-23 20:27:01 | Re: [GENERAL] interesting PHP/MySQL thread |
| Previous Message | nolan | 2003-06-23 18:11:19 | MySQL/PG search times |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ian Harding | 2003-06-23 18:49:58 | Re: SELECT @@IDENTITY |
| Previous Message | Steve Lane | 2003-06-23 18:11:27 | Re: SELECT @@IDENTITY |