2014-05-20 14:26 GMT+03:00 Tom Lane :
> Victor Yegorov writes:
> > How can I enforce pruning to kick in for the initial expressions?
>
> You already found out: use constants. The planner can't remove
> partitions on the basis of clauses involving volatile, or even
> stable, functions, because th
Victor Yegorov writes:
> How can I enforce pruning to kick in for the initial expressions?
You already found out: use constants. The planner can't remove
partitions on the basis of clauses involving volatile, or even
stable, functions, because their results might be different at
runtime.
Greetings.
I have a partitioned table, that can be reproduced the following way:
CREATE TABLE ara (
ara_id int4,
namevarchar(11),
run_id int4,
set_id int4,
created_at timestamp,
CONSTRAINT p_ara PRIMARY KEY (ara_id)
);
DO $partition$
DECLARE
_ta
