Postgres Pro
Downloads
Home   >   mailing lists

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

From Michael Lewis
Subject Re: Query out of memory
Date
Msg-id CAHOFxGpjrXLbvzUv-sszky3LD8wiH4gfu_FTy5VcyVabKyszkw@mail.gmail.com
Whole thread Raw
In response to Re: Query out of memory  (aditya desai <admad123@gmail.com>)
Responses Re: Query out of memory
List pgsql-performance
Tree view
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: Andreas Joseph Krogh
Date:
Subject: Sv: Fwd: Query out of memory
Next
From: aditya desai
Date:
Subject: Re: Query out of memory