Re: Regexps and Indices.

From: Dennis Gearon <gearond(at)cvc(dot)net>
To: brian(at)fulcrum(dot)plus(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Regexps and Indices.
Date: 2003-04-23 15:33:14
Message-ID: 3EA6B23A.5060302@cvc.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

BTW, What **IS** the the language 'C'? I don't talk to people like:

'if( !happy(honey)){
what_went_wrong_today();
}'

;-)

Brian Piatkus wrote:
> Hi
> It turns out to be more than possible. Locale is set by default to en_GB.
> Am I right in assuming that I need only to set LANG=C ? and should I also do
> this for the environment of the running postmaster ?
>
>
> On Tuesday 22 Apr 2003 20:59, you wrote:
>
>>On Tue, 22 Apr 2003, Brian Piatkus wrote:
>>
>>>Hi,
>>> I'm sure that this has come up many times before but :
>>>
>>>I have just upgraded from 7.0.2 to 7.2.2 using the latest Mandrake 9.0
>>>RPMS. The database structure is unchanged but I now find that the db
>>>refuses to use the available index WHERE NAME ~ '^NAME' even with
>>>enable_seqscan set off. Am I missing something ?
>>
>>It's possible that you initialized the database in something other than
>>"C" locale which disables the optimization that uses indexes for
>>regexp/like (see past discussions in the archives for details).
>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 4: Don't 'kill -9' the postmaster
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2003-04-23 15:34:49 Re: Solaris
Previous Message Dennis Gearon 2003-04-23 15:29:16 Re: Left Join Not Using Index?