Sorry, gmail sent uncompleted message
Hi,
Postgres 14.2 (for one more month)
The explain plan and request is here:
The big table (10 billions raws) is split in around 130 partitions, one by month.
the ladate column is the partition key, and it does have 1 value for each partition.
there is an index on the numfic column. the distribution of values for that column may differ before and after 2019 january.
The request is executed in a loop for all ten years of data, year 1,2,3, then year2,3,4 etc
that request is also executed for columns other than cod, one column at a time (there are 107 columns...)
I dont understand why the planner use a filter on the date, as its already within the partition structure.
Thanks,
Marc MILLAS
On Wed, Jun 28, 2023 at 5:22 PM Marc Millas <marc.millas@xxxxxxxxxx> wrote:
Hi,Postgres 14.2 (for one more month)The explain plan and request is here:The big table is split in around 130 partitions, one by month.the ladate column is the partition key, and it does have 1 value for each partition.there is a
