Re: postgresql 10.1 scanning all partitions instead of 1

Sorry it didnt send the whole mail : Hi, I configured range partitions on a date column of my main table(log_full). Each partition represents a day in the month. Every day partition has a list parition of 4 tables on a text column. log_full log_full_01_11_2017 -->

postgresql 10.1 scanning all partitions instead of 1

Hi, I configured range partitions on a date column of my main table(full_table). Each partition represents a day in the month. Every day partition has a list parition of 4 tables on a text column. full table table_01_11_2017 --> table_02_11_2017 .