On Mon, Nov 16, 2020 at 3:57 PM Atul Kumar <akumar14871(at)gmail(dot)com> wrote:
> I only have this one big table in the database of size 3113 GB with rows
> 7661353111.
>
> Right Now the autovacuum setting for that table is set to
>
> {autovacuum_enabled=true,autovacuum_vacuum_scale_factor=0.2,autovacuum_analyze_scale_factor=0.2}
>
>>
>>>
auto-vacuum doesn't care directly about absolute size, it cares about
change (relative to absolute size in many cases, hence the scale factors).
David J.