| From: | Julian Scarfe <julian(dot)scarfe(at)ntlworld(dot)com> |
|---|---|
| To: | Jodi Kanter <jkanter(at)virginia(dot)edu> |
| Cc: | Postgres SQL List <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: order by |
| Date: | 2003-03-27 15:06:01 |
| Message-ID: | BAA8C3D9.25F98%julian.scarfe@ntlworld.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On 27/3/03 14:55, "Jodi Kanter" <jkanter(at)virginia(dot)edu> wrote:
> Other than the sort ordering are there any other problems with NOT having
> the environment set to "C?"
Pattern matching e.g. "where foo ~~ 'bar%'" doesn't use an index on foo
unless the locale is C. This can cause a significant performance hit. For
examples as above you can workaround by defining a substring function for a
functional index, but it's a bit clumsy.
Must get round to doing a fresh initdb one of these days... ;-)
Julian Scarfe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2003-03-27 17:03:21 | Re: Off topic : world database |
| Previous Message | Jodi Kanter | 2003-03-27 14:55:49 | Re: order by |