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
Message-ID: <877dpnuj3r.fsf@gmail.com> (raw)
In-Reply-To: <CAHw75vt85YVo1HVY4jdxF5X5+rm-bwvPxwzjn4rCXk6oNN6C_g@mail.gmail.com>
References: <CACh77r43==uhmv4BCRtwGTA_t_WcgNg6CYzSZPVEzNV9H5Pcxg@mail.gmail.com>
<CACh77r71Ar=o3qK7R38S1vYVgB=0Erp6LoS-aOk8TyVcV-hR7A@mail.gmail.com>
<CAHw75vt85YVo1HVY4jdxF5X5+rm-bwvPxwzjn4rCXk6oNN6C_g@mail.gmail.com>
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?
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: theophilusx@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: How to turnoff autovacuum
In-Reply-To: <877dpnuj3r.fsf@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox