Re: Too few rows expected by Planner on partitioned tables

2020-07-22 Thread Justin Pryzby
On Wed, Jul 22, 2020 at 06:33:17AM +, Julian Wolf wrote: > Hello Justin, > > > thank you very much for your fast response. > > > Is there a correlation between daterange and spacial_feature_id ? > > I am not entirely sure, what you mean by that. Basically, no, they are not > correlated - s

Re: Too few rows expected by Planner on partitioned tables

2020-07-22 Thread Justin Pryzby
On Tue, Jul 21, 2020 at 01:09:22PM +, Julian Wolf wrote: > Hello, > > A description of what you are trying to achieve and what results you expect: > Our database is growing on a daily basis by about 2.5million rows per table > (2 at the moment). Because of that, we decided to partition the da

Re: Too few rows expected by Planner on partitioned tables

2020-07-22 Thread Julian Wolf
Hello Justin, thank you very much for your fast response. > Is there a correlation between daterange and spacial_feature_id ? I am not entirely sure, what you mean by that. Basically, no, they are not correlated - spatial features are places on a map, date ranges are time periods. But, as the