Postgres Pro
Downloads
Home   >   mailing lists

Re: hash joins are causing no space left error - Mailing list pgsql-general

From Michael Lewis
Subject Re: hash joins are causing no space left error
Date
Msg-id CAHOFxGpavffzRjF4Lfw6DEW9qhgv9JDsXiagBgv-BsXN1RfrhA@mail.gmail.com
Whole thread Raw
In response to hash joins are causing no space left error  (Ayub M <hiayub@gmail.com>)
Responses Re: hash joins are causing no space left error
List pgsql-general
Tree view
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?

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Bytea Example
Next
From: Michael Lewis
Date:
Subject: Re: Case insensitive query on existing data