References: 
 <CACh77r43==uhmv4BCRtwGTA_t_WcgNg6CYzSZPVEzNV9H5Pcxg@mail.gmail.com>
 <CACh77r71Ar=o3qK7R38S1vYVgB=0Erp6LoS-aOk8TyVcV-hR7A@mail.gmail.com>
 <CAHw75vt85YVo1HVY4jdxF5X5+rm-bwvPxwzjn4rCXk6oNN6C_g@mail.gmail.com>
User-agent: mu4e 1.5.7; emacs 27.1.50
From: Tim Cross <theophilusx@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: How to turnoff autovacuum
Date: Sun, 13 Dec 2020 02:38:32 +1100
In-reply-to: 
 <CAHw75vt85YVo1HVY4jdxF5X5+rm-bwvPxwzjn4rCXk6oNN6C_g@mail.gmail.com>
Message-ID: <877dpnuj3r.fsf@gmail.com>
MIME-Version: 1.0
Content-Type: text/plain
Precedence: bulk


Keith <keith@keithf4.com> writes:

> 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: 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?
>