Re: Table bloat threshold limit to trigger repack

On Mon, 9 Feb, 2026, 02:16 Adrian Klaver, <adrian.klaver@aklaver.com> wrote:

> On 2/8/26 10:05, Durgamahesh Manne wrote:
> >
>
> > Any recommendations are welcome
> > Please find attached ss
> >
>
> FYI, you can copy and paste from a terminal session in Windows.
>
> Just select the text with the mouse and hit Enter, then Ctl+V to paste
> it somewhere else.
>
> Text in an email is easier to work with if someone wants to set up a
> test case on their machine.
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com


Hi @Adrian Klaver <adrian.klaver@aklaver.com>

In this case autovacuum triggers for every 1hour on toast table

Access method: heap Options: fillfactor=80,
autovacuum_vacuum_cost_limit=2000, autovacuum_vacuum_cost_delay=10,
autovacuum_enabled=true, autovacuum_vacuum_scale_factor=0.1,
autovacuum_vacuum_threshold=100000, autovacuum_analyze_threshold=20000,
toast.autovacuum_enabled=true, toast.autovacuum_vacuum_scale_factor=0.1,
toast.autovacuum_vacuum_cost_limit=3000,
toast.autovacuum_vacuum_threshold=400000


Please let me know if any recommendations
And need to increase speed of autovacuum execution time which takes 5min to
complete
Ram 128gb
Cpu 32

Autovacuum work mem 6gb assigned
Buffer usage limit?
Regards
Durga Mahesh