On Mon, Apr 8, 2024 at 12:35 PM jaya kumar <kumardba27@xxxxxxxxx> 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
