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?
On Mon, Apr 8, 2024 at 9:51 PM Jeff Janes <jeff.janes@xxxxxxxxx> wrote:
On Mon, Apr 8, 2024 at 5:27 AM jaya kumar <kumardba27@xxxxxxxxx> wrote:Hi Team,
The below updated parameter value has been set currently in postgresql.conf file.
autovacuum_analyze_threshold and autovacuum_vacuum_threshold both parameter values set from 50 to 20.
Created one table with 100 records. First, we deleted 21 records. after an autovacuum does not happen automatically. After again I deleted another 20. Out of 100 we delectated 40 records then the autovacuum happened automatically. As per the configuration Autocacuum will automatically delete 21 records in the table but my case does not happen.If you want vacuuming by autovacuum to be driven entirely by autovacuum_vacuum_threshold, then you should set autovacuum_vacuum_scale_factor to zero.Cheers,Jeff
Thanks & Regards,
Jayakumar.S+91-9840864439.
