Postgres Pro
Downloads
Home   >   mailing lists

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

From Dave Cramer
Subject Re: Query out of memory
Date
Msg-id CADK3HHK_gniGo4nNWEkCSzhq8wE+x-0FUb6tGy4kPnF+K6F6Pg@mail.gmail.com
Whole thread Raw
In response to Re: Query out of memory  (Adam Brusselback <adambrusselback@gmail.com>)
List pgsql-performance
Tree view


On Tue, 19 Oct 2021 at 05:54, Adam Brusselback <adambrusselback@gmail.com> 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 250 connections there is no way you could allocate 2G to each one of them if needed


Dave Cramer
www.postgres.rocks

pgsql-performance by date:

Previous
From: Adam Brusselback
Date:
Subject: Re: Query out of memory
Next
From: Justin Pryzby
Date:
Subject: Re: Fwd: Query out of memory