On Mon, Nov 16, 2020 at 3:57 PM Atul Kumar <akumar14871@xxxxxxxxx> 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.
