Re: Query out of memory
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Subject
: Re: Query out of memory
From
: Michael Lewis <mlewis@xxxxxxxxxxx>
Date
: Tue, 19 Oct 2021 07:39:34 -0600
Cc
: Justin Pryzby <pryzby@xxxxxxxxxxxxx>, Pgsql Performance <pgsql-performance@xxxxxxxxxxxxxxxxxxxx>
In-reply-to
: <
CAN0SRDESW-3HbuBDm6nyNceXKjRt0kQcVHi4veokWe-9naeFWA@mail.gmail.com
>
References
: <CAN0SRDHDte88-v4=uhxH1FWU0nt3xBJGTe5hTGj4KvKTtVRDtA@mail.gmail.com> <
CAN0SRDFqJRjuSxNUrTvCQwKuhGv8r5rUn9WnX65kGSsTSxhoCw@mail.gmail.com
> <
20211019102613.GJ4679@telsasoft.com
> <
CAN0SRDESW-3HbuBDm6nyNceXKjRt0kQcVHi4veokWe-9naeFWA@mail.gmail.com
>
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.
Follow-Ups
:
Re: Query out of memory
From:
aditya desai
References
:
Fwd: Query out of memory
From:
aditya desai
Re: Fwd: Query out of memory
From:
Justin Pryzby
Re: Query out of memory
From:
aditya desai
Prev by Date:
Sv: Fwd: Query out of memory
Next by Date:
Re: Query out of memory
Previous by thread:
Re: Query out of memory
Next by thread:
Re: Query out of memory
Index(es):
Date
Thread
[Postgresql General]
[Postgresql PHP]
[PHP Users]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Yosemite]
