| From: | Alban Hertroys <haramrae(at)gmail(dot)com> |
|---|---|
| To: | Marcel van Pinxteren <marcel(dot)van(dot)pinxteren(at)gmail(dot)com> |
| Cc: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, Alex Hunsaker <badalex(at)gmail(dot)com>, Jasen Betts <jasen(at)xnet(dot)co(dot)nz>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Case insensitive collation |
| Date: | 2013-01-21 16:44:44 |
| Message-ID: | CAF-3MvNsNHPmQoVUmbQrELKZ1ske3sO=QcrpUbX9QqGyirHnsQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 21 January 2013 17:25, Marcel van Pinxteren <
marcel(dot)van(dot)pinxteren(at)gmail(dot)com> wrote:
> The other reason, is that I assume that "lower()" adds overhead, so makes
> things slower than they need to be.
> Whether that is true, and if that is a compelling reason, I don't know.
>
Case insensitive collation adds overhead too. It wouldn't surprise me if
that were more than lower() adds - collation is complicated stuff.
--
If you can't see the forest for the trees,
Cut the trees and you'll see there is no forest.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | bhanu udaya | 2013-01-21 16:46:00 | Re: pg_Restore |
| Previous Message | Marcel van Pinxteren | 2013-01-21 16:25:23 | Re: Case insensitive collation |