Do you see any issue in PostgreSQL log files?
Regards,
Ninad Shah
On Tue, 19 Oct 2021 at 16:17, aditya desai wrote:
> Hi Justin,
> Out of memory on pgadmin and psql. I executed it with explain analyze.
> Still going out of memory.
>
> Also currently 250 user connections are not being made. Th
Thanks Michael. I will check this further.
On Tue, Oct 19, 2021 at 7:09 PM Michael Lewis 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
> p
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.
Hi Justin,
Out of memory on pgadmin and psql. I executed it with explain analyze.
Still going out of memory.
Also currently 250 user connections are not being made. There are hardly
10 connections to database. When I run thi query it is going out of memory.
Also this query is part of a view that
On Tue, 19 Oct 2021 at 05:54, Adam Brusselback
wrote:
> That work_mem value could be way too high depending on how much ram your
> server has...which would be a very important bit of information to help
> figure this out. Also, what Postgres / OS versions?
>
WORK_MEM is definitely too high. With
That work_mem value could be way too high depending on how much ram your
server has...which would be a very important bit of information to help
figure this out. Also, what Postgres / OS versions?
