Home > mailing lists

MySQL/PG search times - Mailing list pgsql-general

From	nolan@celery.tssi.com
Subject	MySQL/PG search times
Date	June 23, 2003 18:11:32
Msg-id	20030623181119.942.qmail@celery.tssi.com Whole thread Raw
In response to	Re: [pgsql-advocacy] interesting PHP/MySQL thread (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses	Re: MySQL/PG search times (Bruce Momjian <pgman@candle.pha.pa.us>) Re: MySQL/PG search times (The Hermit Hacker <scrappy@postgresql.org>)
List	pgsql-general

Tree view

> 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

pgsql-general by date:

From: Erik Price
Date: 23 June 2003, 18:10:03
Subject: different datatypes in index scan join

From: Steve Lane
Date: 23 June 2003, 18:12:10
Subject: Re: SELECT @@IDENTITY

MySQL/PG search times - Mailing list pgsql-general

Previous

Next