X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id 9480830F661 for ; Mon, 23 Jun 2003 18:11:31 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 26240-03 for ; Mon, 23 Jun 2003 15:11:20 -0300 (ADT) Received: from celery.tssi.com (celery.tssi.com [198.147.197.6]) by svr1.postgresql.org (Postfix) with SMTP id 0167230F6C9 for ; Mon, 23 Jun 2003 15:11:20 -0300 (ADT) Received: (qmail 943 invoked by uid 1000); 23 Jun 2003 18:11:19 -0000 Message-ID: <20030623181119.942.qmail@celery.tssi.com> From: nolan@celery.tssi.com Subject: MySQL/PG search times To: pgman@candle.pha.pa.us (Bruce Momjian) Date: Mon, 23 Jun 2003 13:11:19 -0500 (CDT) Cc: pgsql-general@postgresql.org (pgsql general list) In-Reply-To: <200306231641.h5NGftj12393@candle.pha.pa.us> from "Bruce Momjian" at Jun 23, 2003 12:41:55 PM X-Mailer: ELM [version 2.5 PL3] MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Spam-Status: No, hits=0.3 tagged_above=0.0 required=5.0 tests=IN_REP_TO, NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200306/1482 X-Sequence-Number: 44410 > 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