Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0

2018-11-30 Thread Pavel Stehule
pá 30. 11. 2018 v 15:37 odesílatel Sanyo Moura napsal: > Hello again, > > At the moment, I've got a palliative solution that has significantly > reduced my planning time. > What I did was nest the partitions by creating sub partitions. > That way, my 730 partitions (2 years of data) were partitio

Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0

2018-11-30 Thread Sanyo Moura
Hello again, At the moment, I've got a palliative solution that has significantly reduced my planning time. What I did was nest the partitions by creating sub partitions. That way, my 730 partitions (2 years of data) were partitioned first in 2 years, and each partitioned year in 12 months. In tu