Thank you David -- I increased this to 1GB as well (seeing as that was the max). We are doing mostly single passes now.
On Mon, Apr 17, 2023 at 7:40 PM David Rowley <dgrowle...@gmail.com> wrote: > On Tue, 18 Apr 2023 at 12:35, peter plachta <pplac...@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. > > David >
