Re: One Partition by list is always chosen by planner

Hello,

thank you for this answer.
I just wanted to add a few informations.

This table has in fact around 20 partitions,

explain select * from wiki_data_part where category='fr' 
returns only 2 partitions (meaning that constraint_exclusion works)

the partition that is always scanned has more than 100 distinct values in
its partition list.

After splitting this partition into 2 partitions the problem is gone ...

For me this is as if the planner was not able to check partitions with too
much values.
There is no error with the query result, just a limited impact on
performances.

Regards
PAscal




--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html