Re: query optimizer questions - Mailing list pgsql-general

From Robert Berger
Subject Re: query optimizer questions
Date
Msg-id 3B40BA18.BB76BB9C@vtiscan.com
Whole thread Raw
In response to Re: query optimizer questions  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
Thanks. How do I set the locale?

> In 7.1, LIKE optimization (i.e., possibly using an index) has been
> disabled unless you are in the C locale because it does not work
> correctly.  You could set your locale to C and re-initdb to get it to work
> again.
>
> --
> Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: query optimizer questions
Next
From: jtp
Date:
Subject: on indexing.