On Fri, Dec 8, 2017 at 3:08 AM, legrand legrand <legrand_legr...@hotmail.com > wrote:
> 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 ? > Is this related to partition-wise aggregation as you saying you found this behaviour on v8 patch? I have tried your testcase on master and see similar plan. I had a look over the plan and I did not see any empty relation at the planning time. > Regards > PAscal > > > > -- > Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers- > f1928748.html > > -- Jeevan Chalke Technical Architect, Product Development EnterpriseDB Corporation The Enterprise PostgreSQL Company Phone: +91 20 66449694 Website: www.enterprisedb.com EnterpriseDB Blog: http://blogs.enterprisedb.com/ Follow us on Twitter: http://www.twitter.com/enterprisedb This e-mail message (and any attachment) is intended for the use of the individual or entity to whom it is addressed. This message contains information from EnterpriseDB Corporation that may be privileged, confidential, or exempt from disclosure under applicable law. If you are not the intended recipient or authorized to receive this for the intended recipient, any use, dissemination, distribution, retention, archiving, or copying of this communication is strictly prohibited. If you have received this e-mail in error, please notify the sender immediately by reply e-mail and delete this message.
