Re: Autovacuum------Doubts - Mailing list pgsql-admin

From Jeff Janes
Subject Re: Autovacuum------Doubts
Date
Msg-id CAMkU=1y-w94FSwo3hA7SdGze3EWEynEk0nLzGSgD52Q2mr6tag@mail.gmail.com
Whole thread Raw
In response to Re: Autovacuum------Doubts  (jaya kumar <kumardba27@gmail.com>)
List pgsql-admin


On Mon, Apr 8, 2024 at 12:35 PM jaya kumar <kumardba27@gmail.com> wrote:
Hi Jeff,

Superb. Now it's working fine as I expected.

If I will set autovacuum_vacuum_scale_factor parameter value=0 is fine.

If I set production database autovacuum_vacuum_scale_factor parameter 0. Do I face any database performance issues?

Yes, your tables will be vacuumed far more than is sensible.  The vacuum will consume resources that would be better used elsewhere, and some tables that need very frequent vacuuming might be starved of it because it is too busy vacuuming other tables which don't really need it.

If zero were generally a better value, it would have been made the default.  This setting is only useful for pedagogical purposes. I have set it to zero on individual tables on occasion, in conjunction with raising their threshold value, when those tables need to keep their visibility map tuned up.

Cheers,

Jeff

pgsql-admin by date:

Previous
From: jaya kumar
Date:
Subject: Re: Autovacuum------Doubts
Next
From: Jeff Janes
Date:
Subject: Re: Work_mem