Re: B-Tree support function number 3 (strxfrm() optimization)

From: Peter Geoghegan <pg(at)heroku(dot)com>
To: Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, Stephen Frost <sfrost(at)snowman(dot)net>, Greg Stark <stark(at)mit(dot)edu>, Noah Misch <noah(at)leadboat(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, 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-06 03:30:17
Message-ID: CAM3SWZTD68yyPb+=t8r0X2+gEc+QozNuLP8fZDkuD-7CZx-WCw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Jun 5, 2014 at 5:37 PM, Peter Geoghegan <pg(at)heroku(dot)com> wrote:
> Even still, the fact that every
> implementation doesn't meet my standard came as a big surprise to me,
> and so I hope that the problem is limited to Mac OSX. I'm slightly
> concerned that all BSD systems are affected by this issue

I tried out my test program with FreeBSD 9.2-RC2. I linked my program
to the system libc. I explicitly set the collation to "en_US.UTF-8". I
can't see any header bytes, and that implementation meets the standard
my configure test looks for generally, so I guess this was only ever
an issue peculiar to Mac OS X (or the collations it ships with?).

I probably should have mentioned before that Windows is still broken
(I don't plan on optimizing Windows at all due to complexity around
the UTF-8 hacks on that platform, but right now the sortsupport
routine just returns NULL, which is not acceptable).

--
Peter Geoghegan

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2014-06-06 03:32:41 Re: Proposing pg_hibernate
Previous Message Tom Lane 2014-06-06 02:54:16 Re: Suppressing unused subquery output columns