On Tue, Dec 26, 2017 at 11:04:55AM +0100, Michelle Konzack wrote: > I like to make the partitions smaller, but the documentation say, you > should not dare to make several 1000 partitions.. Even more than a hundred may be already risky in my opinion here. The issue with a large number of partitioning using the pre-9.6 grammar comes from the planning time which sky-rockets because the optimizer uses a O(N^2) algorithm to consider all the partitions. The v10 grammar does not take care of this planning problem as far as I recall, but v11 gets that better for partition-wise joins if my memory does not fail me. -- Michael
Attachment:
signature.asc
Description: PGP signature
