On Mon, 9 Feb, 2026, 02:16 Adrian Klaver, <[email protected]> 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 > [email protected] Hi @Adrian Klaver <[email protected]> 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
