Re: Lowering the minimum value for maintenance_work_mem

2024-05-19 Thread John Naylor
On Mon, May 20, 2024 at 11:59 AM Masahiko Sawada wrote: > > On Fri, May 17, 2024 at 5:55 AM Andres Freund wrote: > > I think we should consider lowering the minimum setting of > > maintenance_work_mem to the minimum of work_mem. > > +1 for lowering the minimum value of maintenance_work_mem. I've

Re: Lowering the minimum value for maintenance_work_mem

2024-05-19 Thread Masahiko Sawada
On Fri, May 17, 2024 at 5:55 AM Andres Freund wrote: > > Hi, > > In the subthread at [1] I needed to trigger multiple rounds of index vacuuming > within one vacuum. > > It turns out that with the new dead tuple implementation, that got actually > somewhat expensive. Particularly if all tuples on a