Re: Autovacuum------Doubts

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Autovacuum------Doubts
Дата
Msg-id CAMkU=1w9Zgxc6ZSPS1MN7W=psx7fpH-QYt=0c9gPYar3AK2gGA@mail.gmail.com
обсуждение исходный текст
Ответ на [MASSMAIL]Autovacuum------Doubts  (jaya kumar <kumardba27@gmail.com>)
Ответы Re: Autovacuum------Doubts  (jaya kumar <kumardba27@gmail.com>)
Список pgsql-admin
On Mon, Apr 8, 2024 at 5:27 AM jaya kumar <kumardba27@gmail.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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Frank Wang
Дата:
Сообщение: A good tool for PostgreSQL admin - PuttyGPT = Putty + ChatGPT
Следующее
От: jaya kumar
Дата:
Сообщение: Re: Autovacuum------Doubts