Re: Query out of memory

From: Michael Lewis <mlewis(at)entrata(dot)com>
To: aditya desai <admad123(at)gmail(dot)com>
Cc: Justin Pryzby <pryzby(at)telsasoft(dot)com>, Pgsql Performance <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: Re: Query out of memory
Date: 2021-10-19 13:39:34
Message-ID: CAHOFxGpjrXLbvzUv-sszky3LD8wiH4gfu_FTy5VcyVabKyszkw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance pgsql-sql

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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message aditya desai 2021-10-19 13:48:04 Re: Query out of memory
Previous Message Andreas Joseph Krogh 2021-10-19 11:08:03 Sv: Fwd: Query out of memory

Browse pgsql-sql by date

  From Date Subject
Next Message Jian He 2021-10-19 13:45:50 create a procedure based on column data change in postgrersql
Previous Message Andreas Joseph Krogh 2021-10-19 11:08:03 Sv: Fwd: Query out of memory