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

On Wed, Sep 20, 2017 at 2:06 AM, Ashutosh Bapat
<ashutosh.bapat@enterprisedb.com> wrote:
> In this case, both tables use same collation while comparing the rows,
> so result is different from the merge join result. Hash join executed
> on local server and the same executed on foreign server (by importing
> local table to the foreign server) would also differ.

Not really, because collatable types like text have the same equality
behavior, regardless of collation. (I would prefer it if they didn't
in at least some cases, but we don't have case insensitive collations
yet.)

I think that Corey describes a user hostile behavior. I feel that we
should try to do better here.

-- 
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