Re: Query out of memory

Поиск
Список
Период
Сортировка
От Dave Cramer
Тема Re: Query out of memory
Дата
Msg-id CADK3HHK_gniGo4nNWEkCSzhq8wE+x-0FUb6tGy4kPnF+K6F6Pg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Query out of memory  (Adam Brusselback <adambrusselback@gmail.com>)
Список pgsql-performance


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 по дате отправления:

Предыдущее
От: Adam Brusselback
Дата:
Сообщение: Re: Query out of memory
Следующее
От: Justin Pryzby
Дата:
Сообщение: Re: Fwd: Query out of memory