| 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: | Postg젠 토토SQL : |
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
| 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 |