Re: Need to improve performance

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Vassili A Akimov <vassili(at)erols(dot)com>
Cc: Andrew Snow <als(at)fl(dot)net(dot)au>, "Pgsql-General(at)Postgresql(dot) Org" <pgsql-general(at)postgresql(dot)org>, mitch(at)venux(dot)net
Subject: Re: Need to improve performance
Date: 2000-06-23 18:06:50
Message-ID: 200006231806.OAA19976@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

>
> Thank you gentelmen! It seems that regexp was the reason! I enabled
> likeplanning and it i=didn't improve the performance until I replaced '~*' with
> 'LIKE'. Thank you again!

The issue is that ~ and LIKE have similar performance. ~* is
case-insensitive, and can not used indexes.

--
Bruce Momjian | http://www.op.net/~candle
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Denis Perchine 2000-06-23 18:48:53 Re: Re: [GENERAL] libpq error codes
Previous Message Jim Mercer 2000-06-23 17:54:16 Re: followup to SELECT/INSERT problem

Browse pgsql-sql by date

  From Date Subject
Next Message Jeff MacDonald 2000-06-23 18:53:45 query failed , don't know why
Previous Message Vassili A Akimov 2000-06-23 17:43:52 Re: Need to improve performance