Re: Autovacuum------Doubts

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(dot)janes(at)gmail(dot)com> wrote:

> On Mon, Apr 8, 2024 at 5:27 AM jaya kumar <kumardba27(at)gmail(dot)com> 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.