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

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: [HACKERS] Varying results when using merge joins overpostgres_fdw vs hash joins
Дата
Msg-id bb0ff497-7ac9-6a61-ed7b-3663516ac659@2ndquadrant.com
обсуждение исходный текст
Ответ на Re: [HACKERS] Varying results when using merge joins over postgres_fdw vs hash joins  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [HACKERS] Varying results when using merge joins over postgres_fdw vs hash joins  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On 9/20/17 12:06, Tom Lane wrote:
> I'm tempted to propose that we invent some kind of "unknown"
> collation, which the planner would have to be taught to not equate to any
> other column collation (not even other instances of "unknown"), and that
> postgres_fdw's IMPORT ought to label remote columns with that collation
> unless specifically told to do otherwise.  Then it's on the user's head
> if he tells us to do the wrong thing; but we won't produce incorrect
> plans by default.

OID 0 might already work that way, depending on the details.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


-- 
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 по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: [HACKERS] Windows warnings from VS 2017
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] compress method for spgist - 2