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
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
