| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Peter Geoghegan <pg(at)heroku(dot)com> |
| Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>, Stephen Frost <sfrost(at)snowman(dot)net>, Greg Stark <stark(at)mit(dot)edu>, Noah Misch <noah(at)leadboat(dot)com>, Thom Brown <thom(at)linux(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: B-Tree support function number 3 (strxfrm() optimization) |
| Date: | 2014-06-12 21:18:40 |
| Message-ID: | 14745.1402607920@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Peter Geoghegan <pg(at)heroku(dot)com> writes:
> ... In any case it's pretty clear that a goal of
> the glibc implementation is to concentrate as much entropy as possible
> into the first part of the string, and that's the important point.
> This makes perfect sense, and is why I was so incredulous about the
> Mac behavior.
I think this may be another facet of something we were already aware of,
which is that the UTF8 locales on OS X pretty much suck. It's fairly
clear that Apple has put no effort into achieving more than minimal
standards compliance for those. Sorting doesn't work as expected in
those locales, for example.
Still, that's reality, and any proposal to rely on strxfrm is going to
have to deal with it :-(
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gregory Smith | 2014-06-12 22:33:20 | Re: API change advice: Passing plan invalidation info from the rewriter into the planner? |
| Previous Message | Noah Misch | 2014-06-12 21:09:41 | Re: lo_create(oid, bytea) breaks every extant release of libpq |