Hi Atul,
On Tue, Nov 17, 2020 at 12:05 AM David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:
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.
David is correct.
If it helps, I put together a few thoughts and own experience on a blog:
Hope you find it useful.
--
Olivier Gautherot
