Re: hash joins are causing no space left error

From: Michael Lewis <mlewis(at)entrata(dot)com>
To: Ayub M <hiayub(at)gmail(dot)com>
Cc: PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: hash joins are causing no space left error
Date: 2020-08-13 17:09:36
Message-ID: CAHOFxGpavffzRjF4Lfw6DEW9qhgv9JDsXiagBgv-BsXN1RfrhA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Henry Francisco Garcia Cortez 2020-08-13 17:10:03 Fwd: changing password pgagent service account
Previous Message Henry Francisco Garcia Cortez 2020-08-13 17:07:53 changing password pgagent service account