On Tue, 19 Oct 2021 at 05:54, Adam Brusselback <adambrusselback@xxxxxxxxx> 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
