Fra: David Rowley Sendt: 12. maj 2021 02:34
>>
>> ok i think i just may be there is very less data , hence no index scan, no
>> pruning.
>>
>> when i try to force seq_scan off,
>>
>
>Unfortunately, no run-time pruning occurred in the above plan.
>
>The fact that the above plan uses Append made
>
>Sorry,
>
>I made a major mistake. I somehow saw the period and period_version as the
>same.
>so, yes partitions are not pruned here. So my suggestion makes no sense.
Thats quite ok. I think my plan now is to have a table returning function that
executes a query dynamically. The query has a wh
