Re: Query out of memory

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

Re: Query out of memory

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

Re: Query out of memory

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.

Sv: Fwd: Query out of memory

På tirsdag 19. oktober 2021 kl. 07:58:46, skrev aditya desai < admad...@gmail.com >: Sending to a performance group instead of PLPGSQL. . . Hi, I am running the below query. Table has 21 million records. I get an Out Of Memory error after a while.(from both pgadmi

Re: Query out of memory

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

Re: Fwd: Query out of memory

On Tue, Oct 19, 2021 at 11:28:46AM +0530, aditya desai wrote: > I am running the below query. Table has 21 million records. I get an Out Of > Memory error after a while.(from both pgadmin and psql). Can someone review Is the out of memory error on the client side ? Then you've simply returned more

Re: Query out of memory

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

Re: Query out of memory

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?

Fwd: Query out of memory

Sending to a performance group instead of PLPGSQL. . . Hi, I am running the below query. Table has 21 million records. I get an Out Of Memory error after a while.(from both pgadmin and psql). Can someone review DB parameters given below. select t.*,g.column,a.column from gk_staging g, transaction