Hi All,
I have a question about partition pruning.
Does runtime partition pruning (ie. pruning performed during execution) work with partition wise aggregates?
1) I have a setup with a mix of foreign (postgres_fdw) and local partitions.
2) I want to perform an aggregate query and I want the aggregates to be pushed down to remote servers.
To make it possible I set enable_partitionwise_aggregate to on.
My observation is that partition pruning works during planning time
But with plan_cache_mode = force_generic_plan, explain analyse execute prepared_stmt(params) shows that
_all_ partitions are scanned (and queries sent to remote severs for all remote partitions).
When I set enable_hashagg to false runtime partition pruning works but no pushdown is taking place.
Am I missing something or runtime partition pruning is not going to work for generic plans and partitionwise
aggregates?
Thanks,
Michal
