On 2015/09/28 17:04, David Rowley wrote:
> On 28 September 2015 at 20:36, Amit Langote <langote_amit...@lab.ntt.co.jp>
> wrote:
>
>>
>> Did you perhaps attach a version of the patch you didn't intend to?
>>
>
> Oops. It seems so.
>
> Please find the correct version attached.
Thanks, this one works fine.
By the way, you may have noticed that the append_rel_list would be broken
if the proposed optimization is applied to a appendrel parent.
CREATE TABLE sale_1() INHERITS(sale);
CREATE TABLE sale_2() INHERITS(sale);
EXPLAIN SELECT count(*) FROM sale;
QUERY PLAN
------------------------------------------------------
Finalize Aggregate (cost=0.01..0.02 rows=1 width=0)
-> Result (cost=0.00..0.01 rows=1 width=0)
One-Time Filter: false
(3 rows)
Moreover, would partial aggregation work below Append?
Thanks,
Amit
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
