Re: [HACKERS] Varying results when using merge joins overpostgres_fdw vs hash joins - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: [HACKERS] Varying results when using merge joins overpostgres_fdw vs hash joins
Date
Msg-id bb0ff497-7ac9-6a61-ed7b-3663516ac659@2ndquadrant.com
Whole thread Raw
In response to Re: [HACKERS] Varying results when using merge joins over postgres_fdw vs hash joins  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [HACKERS] Varying results when using merge joins over postgres_fdw vs hash joins  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Michael Paquier
Date:
Subject: Re: [HACKERS] Windows warnings from VS 2017
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] compress method for spgist - 2