Re: Partition-wise aggregation/grouping

From: legrand legrand <legrand_legrand(at)hotmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Partition-wise aggregation/grouping
Date: 2017-12-07 21:38:43
Message-ID: 1512682723811-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David G. Johnston 2017-12-07 21:41:55 Re: Add %r substitution for psql prompts to show recovery status
Previous Message Thomas Munro 2017-12-07 21:30:47 Re: ERROR: too many dynamic shared memory segments