Re: How to turnoff autovacuum

Friends don’t let friends turn off auto vacuum

On Sat, Dec 12, 2020 at 20:27 mark armon <1994hejian(at)gmail(dot)com> wrote:

> you got me.
> For the following tutorial purpose. I guess I am kind of getting it. The
> following are my thoughts. If is not correct, kindly spare time tell me.
>
> - turning off autovacuum. Now I need to clean old data to reclaim the
> disk space by *vacuum full *
>
> Not sure about understanding the plain vacuum. example: table a has 1m
> rows with lower case string data. data storage is 50MB.
>
> 1. update by upper () function.
> 2. step2. vacuum table a
> 3. step3. delete 500000 row
> 4. step4. vacuum table a
>
> In step1, space is 100MB (one version of 50MB lower case string, one
> version of upper case string).
> In step2, the space is still 100MB. It's just to make some pages have
> content, then it clear the content, but the space is still there.
> in Step3, I guess the space would be 125MB. I guess it's just like a new
> version of the table a store there.
> In step4, I guess the space would be 100MB.
>
>
>
>
>
> On Dec 12, 2020, at 20:57, Keith <keith(at)keithf4(dot)com> wrote:
>
> 
>
>
> On Sat, Dec 12, 2020 at 12:31 AM mark armon <1994hejian(at)gmail(dot)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?
>
> Keith
>
> --
Wells Oliver
wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>