pg_pathman icon indicating copy to clipboard operation
pg_pathman copied to clipboard

Prune partitions at runtime selecting from view

Open koxt opened this issue 6 years ago • 0 comments

Problem description

Table partitioned by date_cln.

When I use condition date_cln >= (select date_trunc('year', now() - interval '1 year')) inside sql function or reqular SELECT - planner successfully prune archival partitions and RuntimeAppend node appears in execution plan.

When I use this condition inside view, then select - no RuntimeAppend node and archival partitions in plan

Is it bug or pg_pathman doesn't support partitioned tables inside views ?

Environment

select version(); PostgreSQL 9.6.12 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-36), 64-bit

select pathman_version(); 1.5.4

koxt avatar Feb 26 '19 09:02 koxt