On Wed, Aug 12, 2020 at 5:52 PM Ayub M <hiayub(at)gmail(dot)com> wrote:
>
> This is PostgreSQL 11 on AWS, there is a mview query in this OLAP
> database, the tables involved are huge - 50-100m records on average records
> hundreds of columns in most cases.
>
How many tables and how many partitions each? Can you share an EXPLAIN
output? Are the tables being joined partitioned in such a way to allow
partition wise joins? Have you enabled partition wise joins config? There
are many enhancements for partitioning in PG12, do you have the option to
upgrade?