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