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
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 faced
the same situation.
Even if a shared tidstore is empty, TidStoreMemoryUsage() returns
256kB because it's the minimum se
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 all pages get deleted, the
representation is just "too dense".