Re: How to turnoff autovacuum

Поиск
Список
Период
Сортировка
От Keith
Тема Re: How to turnoff autovacuum
Дата
Msg-id CAHw75vt85YVo1HVY4jdxF5X5+rm-bwvPxwzjn4rCXk6oNN6C_g@mail.gmail.com
обсуждение исходный текст
Ответ на Fwd: How to turnoff autovacuum  (mark armon <1994hejian@gmail.com>)
Ответы Re: How to turnoff autovacuum
Re: How to turnoff autovacuum
Список pgsql-admin


On Sat, Dec 12, 2020 at 12:31 AM mark armon <1994hejian@gmail.com> wrote:

Just follow the tutorial. In the tutorial I need to set the autovacuum off. 
Here is how I set the autovacuum off. 
  1. Locate the postgresql.conf.  
  2. edit the postgresql.conf using notepad. As the picture attached. Previously it's on now it's off. 
  3. close and save postgresql.conf then open service-msc
  4. restart  the postgresql service. 
  5. open psql type: show autovacuum; 
But the result is ON. 

So that's my knowledge about  how to set the parameters. But it failed. So please tell me how to set the autovacuum off. 
image.png


I have to ask the question, why are you turning autovacuum off?  You do realize the consequences of doing so and are taking the necessary precautions of managing vacuuming yourself if you do so, correct?

Keith
Вложения

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

Предыдущее
От: Amine Tengilimoglu
Дата:
Сообщение: Re: How to turnoff autovacuum
Следующее
От: Tim Cross
Дата:
Сообщение: Re: How to turnoff autovacuum