On Wed, Aug 12, 2020 at 5:52 PM Ayub M <hiayub@gmail.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?