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