Re: [HACKERS] Varying results when using merge joins overpostgres_fdw vs hash joins

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: [HACKERS] Varying results when using merge joins overpostgres_fdw vs hash joins
Дата
Msg-id CAH2-WznrUkVyyNLfPnf7iJ0_xUtaLQ+Wjp27Kii6HOXQ1jRQog@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] Varying results when using merge joins over postgres_fdw vs hash joins  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Wed, Sep 20, 2017 at 9:35 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> TBH, the more I learn about ICU, the less faith I have in the proposition
> that it's going to fix anything at all for us in this area.  It seems to
> be just about as squishy as glibc in terms of locale identification,
> if not worse.

That may be our fault, to a significant degree. Did you read my mail
from yesterday, over on the "CREATE COLLATION does not sanitize ICU's
BCP 47 language tags" thread? I think that we've been incorrectly
specifying the locale name that is passed to ucol_open() this whole
time. At least, for ICU versions prior to ICU 54. This will need to be
addressed very soon.

-- 
Peter Geoghegan


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Varying results when using merge joins over postgres_fdw vs hash joins
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: [HACKERS] coverage analysis improvements