Обсуждение: AUTOVACUUM

Поиск
Список
Период
Сортировка

AUTOVACUUM

От
Siraj G
Дата:
Hello -

What are the dictionary objects/scripts we have to check if AUTOVACUUM parameters are set correctly and need any tuning?

Regards
Siraj

Re: AUTOVACUUM

От
Ron
Дата:
On 10/30/23 06:20, Siraj G wrote:
> Hello -
>
> What are the dictionary objects/scripts we have to check if AUTOVACUUM 
> parameters are set correctly and need any tuning?

On Linux:
psql -c "SHOW ALL;" | grep "^ autovacuu"


Then exit $PGDATA/postgresql.conf

-- 
Born in Arizona, moved to Babylonia.



Re: AUTOVACUUM

От
Siraj G
Дата:
Hi Ron

Thank you. I had this info already, but I am looking for queries/scripts/reports for analysis purposes if these need to be tuned.

Regards
Siraj

On Mon, Oct 30, 2023 at 8:42 AM Ron <ronljohnsonjr@gmail.com> wrote:
On 10/30/23 06:20, Siraj G wrote:
> Hello -
>
> What are the dictionary objects/scripts we have to check if AUTOVACUUM
> parameters are set correctly and need any tuning?

On Linux:
psql -c "SHOW ALL;" | grep "^ autovacuu"


Then exit $PGDATA/postgresql.conf

--
Born in Arizona, moved to Babylonia.