Re: Query out of memory

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Thanks Michael. I will check this further.

On Tue, Oct 19, 2021 at 7:09 PM Michael Lewis <mlewis@xxxxxxxxxxx> 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.

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux