Too few rows expected by Planner on partitioned tables

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 data, especially, as we are pre-aggregating the data for weeks, months,

Re: Too few rows expected by Planner on partitioned tables

w.invenium.io/images/invenium_triangle_64.png] Julian P. Wolf | Invenium Data Insights GmbH julian.w...@invenium.io | +43 664 88 199 013 Herrengasse 28 | 8010 Graz | www.invenium.io From: Justin Pryzby Sent: Tuesday, July 21, 2020 7:27 PM To: Julian Wolf Cc: pgsql-

Re: Too few rows expected by Planner on partitioned tables

__ From: Justin Pryzby Sent: Wednesday, July 22, 2020 4:40 PM To: Julian Wolf Cc: pgsql-performance Postgres Mailing List Subject: Re: Too few rows expected by Planner on partitioned tables On Tue, Jul 21, 2020 at 01:09:22PM +, Julian Wolf wrote: > Hello, > >

Re: Too few rows expected by Planner on partitioned tables

/invenium_triangle_64.png] Julian P. Wolf | Invenium Data Insights GmbH julian.w...@invenium.io | +43 664 88 199 013 Herrengasse 28 | 8010 Graz | www.invenium.io From: Justin Pryzby Sent: Wednesday, July 22, 2020 4:40 PM To: Julian Wolf Cc: pgsql-performance Postgres