Re: Aggregate Push Down - Performing aggregation on foreign server

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Jeevan Chalke <jeevan(dot)chalke(at)enterprisedb(dot)com>, Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Aggregate Push Down - Performing aggregation on foreign server
Date: 2016-10-21 15:20:57
Message-ID: 5328.1477063257@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Robert Haas <robertmhaas(at)gmail(dot)com> writes:
> On Fri, Oct 21, 2016 at 10:47 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> dromedary seems to have found one, or at least an unstable test result.

> OK, looking at that now. Thanks.

Looking at further failures, it looks like 32-bit machines in general
get that result. Might be just a cost estimation difference.

Also, some of the windows machines are folding "sqrt(2)" to a different
constant than is hard-wired into the expected-result file. That's
slightly annoying because it calls into question whether we can ship
floating-point computations to the far end at all :-(.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jim Nasby 2016-10-21 15:28:21 Re: Improve output of BitmapAnd EXPLAIN ANALYZE
Previous Message Jim Nasby 2016-10-21 15:15:21 Re: Fun fact about autovacuum and orphan temp tables