Postgres Pro
Downloads
Home   >   mailing lists

Re: How to turnoff autovacuum - Mailing list pgsql-admin

From Keith
Subject Re: How to turnoff autovacuum
Date
Msg-id CAHw75vt85YVo1HVY4jdxF5X5+rm-bwvPxwzjn4rCXk6oNN6C_g@mail.gmail.com
Whole thread Raw
In response to Fwd: How to turnoff autovacuum  (mark armon <1994hejian@gmail.com>)
Responses Re: How to turnoff autovacuum  (Tim Cross <theophilusx@gmail.com>)
Re: How to turnoff autovacuum  (mark armon <1994hejian@gmail.com>)
List pgsql-admin
Tree view


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
Attachment

pgsql-admin by date:

Previous
From: Amine Tengilimoglu
Date:
Subject: Re: How to turnoff autovacuum
Next
From: Tim Cross
Date:
Subject: Re: How to turnoff autovacuum