Postgres Pro
Downloads
Home   >   mailing lists

Re: Query out of memory - Mailing list pgsql-performance

From aditya desai
Subject Re: Query out of memory
Date
Msg-id CAN0SRDEFCMLu6Ue_zR0=okw2GZjCOoWXvdqE0d-idGb8DasWVg@mail.gmail.com
Whole thread Raw
In response to Re: Query out of memory  (Michael Lewis <mlewis@entrata.com>)
List pgsql-performance
Tree view
Thanks Michael. I will check this further.

On Tue, Oct 19, 2021 at 7:09 PM Michael Lewis <mlewis@entrata.com> wrote:
Check explain plan, change work mem to 100MBs and then check explain plan again. If it changed, then try explain analyze.

Work mem is limit is used per node in the plan, so especially with partitioned tables, that limit is way too high.

pgsql-performance by date:

Previous
From: Michael Lewis
Date:
Subject: Re: Query out of memory
Next
From: Mithran Kulasekaran
Date:
Subject: Postgres views cannot use both union and join/where