Re: Partition-wise aggregation/grouping - Mailing list pgsql-hackers

From legrand legrand
Subject Re: Partition-wise aggregation/grouping
Date
Msg-id 1512682723811-0.post@n3.nabble.com
Whole thread Raw
In response to Re: [HACKERS] Partition-wise aggregation/grouping  (Jeevan Chalke <jeevan.chalke@enterprisedb.com>)
Responses Re: Partition-wise aggregation/grouping
List pgsql-hackers
Hello,

I'm testing Partition wise and found a strange result in V8 patch
see  init_star_schema_agg.sql
<http://www.postgresql-archive.org/file/t348768/init_star_schema_agg.sql>  

Explain gives  
  ->  Seq Scan on facts_p2  (...) (actual time=0.012..0.012 rows=1 loops=1)
for partitions that are joined with empty partitions

I was expecting a message saying that partition facts_p2 was not accessed

Am I wrong ?
Regards
PAscal



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Add %r substitution for psql prompts to show recovery status
Next
From: "David G. Johnston"
Date:
Subject: Re: Add %r substitution for psql prompts to show recovery status