On Tue, 18 Apr 2023 at 12:35, peter plachta <pplachta@gmail.com> wrote: > I increased work_mem to 2Gb
maintenance_work_mem is the configuration option that vacuum uses to control how much memory it'll make available for storage of dead tuples. I believe 1GB would allow 178,956,970 tuples to be stored before multiple passes would be required. The chunk of memory for dead tuple storage is capped at 1GB.