| From: | Dave Cramer <davecramer(at)postgres(dot)rocks> |
|---|---|
| To: | Adam Brusselback <adambrusselback(at)gmail(dot)com> |
| Cc: | aditya desai <admad123(at)gmail(dot)com>, Pgsql Performance <pgsql-performance(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Query out of memory |
| Date: | 2021-10-19 09:57:37 |
| Message-ID: | CADK3HHK_gniGo4nNWEkCSzhq8wE+x-0FUb6tGy4kPnF+K6F6Pg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance pgsql-sql |
On Tue, 19 Oct 2021 at 05:54, Adam Brusselback <adambrusselback(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Justin Pryzby | 2021-10-19 10:26:13 | Re: Fwd: Query out of memory |
| Previous Message | Adam Brusselback | 2021-10-19 09:54:05 | Re: Query out of memory |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Justin Pryzby | 2021-10-19 10:26:13 | Re: Fwd: Query out of memory |
| Previous Message | Adam Brusselback | 2021-10-19 09:54:05 | Re: Query out of memory |