Re: Partition-wise aggregation/grouping

Thank you for the answer This is a miss understanding of hash join behaviour on my side. That means that there is at less on line read in facts_p2 part even if the second table partition of the hash join operation is empty. I will remember it now ;o) Regards PAscal -- Sent from: http://www.po

Re: Partition-wise aggregation/grouping

On Fri, Dec 8, 2017 at 3:08 AM, legrand legrand wrote: > Hello, > > I'm testing Partition wise and found a strange result in V8 patch > see init_star_schema_agg.sql > > > Explain gives > -> Seq Scan on facts_p2 (...) (

Re: Partition-wise aggregation/grouping

Hello, I'm testing Partition wise and found a strange result in V8 patch see 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 jo