pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedFwd: How to turnoff autovacuum
13+ messages / 8 participants
[nested] [flat]
* Fwd: How to turnoff autovacuum
@ 2020-12-12 05:30 mark armon <1994hejian@gmail.com>
2020-12-12 05:51 ` Re: How to turnoff autovacuum Amine Tengilimoglu <aminetengilimoglu@gmail.com>
2020-12-12 15:26 ` Re: How to turnoff autovacuum Keith <keith@keithf4.com>
0 siblings, 2 replies; 13+ messages in thread
From: mark armon @ 2020-12-12 05:30 UTC (permalink / raw)
To: pgsql-admin
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]
Attachments:
image.png (image/png, 158.8K) download
view image
* Re: How to turnoff autovacuum
2020-12-12 05:30 Fwd: How to turnoff autovacuum mark armon <1994hejian@gmail.com>
@ 2020-12-12 05:51 ` Amine Tengilimoglu <aminetengilimoglu@gmail.com>
2020-12-12 06:34 ` Re: How to turnoff autovacuum mark armon <1994hejian@gmail.com>
1 sibling, 1 reply; 13+ messages in thread
From: Amine Tengilimoglu @ 2020-12-12 05:51 UTC (permalink / raw)
To: mark armon <1994hejian@gmail.com>; +Cc: pgsql-admin
You need to delete # sign from the line head. It should be like this
autovacuum = off
12 Ara 2020 Cmt 08:31 tarihinde mark armon <1994hejian@gmail.com> şunu
yazdı:
>
> 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]
>
Attachments:
image.png (image/png, 158.8K) download
view image
* Re: How to turnoff autovacuum
2020-12-12 05:30 Fwd: How to turnoff autovacuum mark armon <1994hejian@gmail.com>
2020-12-12 05:51 ` Re: How to turnoff autovacuum Amine Tengilimoglu <aminetengilimoglu@gmail.com>
@ 2020-12-12 06:34 ` mark armon <1994hejian@gmail.com>
2020-12-12 06:39 ` Re: How to turnoff autovacuum Amine Tengilimoglu <aminetengilimoglu@gmail.com>
0 siblings, 1 reply; 13+ messages in thread
From: mark armon @ 2020-12-12 06:34 UTC (permalink / raw)
To: Amine Tengilimoglu <aminetengilimoglu@gmail.com>; +Cc: pgsql-admin
resolved. Thank you very much!!!
On Sat, Dec 12, 2020 at 11:21 AM Amine Tengilimoglu <
aminetengilimoglu@gmail.com> wrote:
> You need to delete # sign from the line head. It should be like this
>
> autovacuum = off
>
> 12 Ara 2020 Cmt 08:31 tarihinde mark armon <1994hejian@gmail.com> şunu
> yazdı:
>
>>
>> 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]
>>
>
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: How to turnoff autovacuum
2020-12-12 05:30 Fwd: How to turnoff autovacuum mark armon <1994hejian@gmail.com>
2020-12-12 05:51 ` Re: How to turnoff autovacuum Amine Tengilimoglu <aminetengilimoglu@gmail.com>
2020-12-12 06:34 ` Re: How to turnoff autovacuum mark armon <1994hejian@gmail.com>
@ 2020-12-12 06:39 ` Amine Tengilimoglu <aminetengilimoglu@gmail.com>
0 siblings, 0 replies; 13+ messages in thread
From: Amine Tengilimoglu @ 2020-12-12 06:39 UTC (permalink / raw)
To: mark armon <1994hejian@gmail.com>; +Cc: pgsql-admin
You're welcome!
12 Ara 2020 Cmt 09:34 tarihinde mark armon <1994hejian@gmail.com> şunu
yazdı:
>
> resolved. Thank you very much!!!
>
> On Sat, Dec 12, 2020 at 11:21 AM Amine Tengilimoglu <
> aminetengilimoglu@gmail.com> wrote:
>
>> You need to delete # sign from the line head. It should be like this
>>
>> autovacuum = off
>>
>> 12 Ara 2020 Cmt 08:31 tarihinde mark armon <1994hejian@gmail.com> şunu
>> yazdı:
>>
>>>
>>> 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]
>>>
>>
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: How to turnoff autovacuum
2020-12-12 05:30 Fwd: How to turnoff autovacuum mark armon <1994hejian@gmail.com>
@ 2020-12-12 15:26 ` Keith <keith@keithf4.com>
2020-12-12 15:38 ` Re: How to turnoff autovacuum Tim Cross <theophilusx@gmail.com>
2020-12-13 04:27 ` Re: How to turnoff autovacuum mark armon <1994hejian@gmail.com>
1 sibling, 2 replies; 13+ messages in thread
From: Keith @ 2020-12-12 15:26 UTC (permalink / raw)
To: mark armon <1994hejian@gmail.com>; +Cc: 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: 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
Attachments:
image.png (image/png, 158.8K) download
view image
* Re: How to turnoff autovacuum
2020-12-12 05:30 Fwd: How to turnoff autovacuum mark armon <1994hejian@gmail.com>
2020-12-12 15:26 ` Re: How to turnoff autovacuum Keith <keith@keithf4.com>
@ 2020-12-12 15:38 ` Tim Cross <theophilusx@gmail.com>
2020-12-12 16:04 ` Re: How to turnoff autovacuum Oleksandr Mazyar <drumenbassik@gmail.com>
1 sibling, 1 reply; 13+ messages in thread
From: Tim Cross @ 2020-12-12 15:38 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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?
>
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: How to turnoff autovacuum
2020-12-12 05:30 Fwd: How to turnoff autovacuum mark armon <1994hejian@gmail.com>
2020-12-12 15:26 ` Re: How to turnoff autovacuum Keith <keith@keithf4.com>
2020-12-12 15:38 ` Re: How to turnoff autovacuum Tim Cross <theophilusx@gmail.com>
@ 2020-12-12 16:04 ` Oleksandr Mazyar <drumenbassik@gmail.com>
2020-12-12 16:15 ` Re: How to turnoff autovacuum David G. Johnston <david.g.johnston@gmail.com>
2020-12-12 22:48 ` Re: How to turnoff autovacuum Tim Cross <theophilusx@gmail.com>
0 siblings, 2 replies; 13+ messages in thread
From: Oleksandr Mazyar @ 2020-12-12 16:04 UTC (permalink / raw)
To: Tim Cross <theophilusx@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
What is it aurovacuum?
сб, 12 дек. 2020 г., 17:42 Tim Cross <theophilusx@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?
> >
>
> From what the OP wrote, he is following a tutorial, so I would assume
> learning about Postgres. I would argue it is a poor example for the
> tutorial to use if all they want to demonstrate is altering the postgres
> configuration, but without the full context from the tutorial, it is
> difficult to know. If the tutorial wanted to demonstrate how to disable
> autovacuum, a far better example would be to show how to disable it on a
> specific table as just showing how to disable it globally is a very
> dangerous lesson to teach.
>
>
>
> --
> Tim Cross
>
>
>
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: How to turnoff autovacuum
2020-12-12 05:30 Fwd: How to turnoff autovacuum mark armon <1994hejian@gmail.com>
2020-12-12 15:26 ` Re: How to turnoff autovacuum Keith <keith@keithf4.com>
2020-12-12 15:38 ` Re: How to turnoff autovacuum Tim Cross <theophilusx@gmail.com>
2020-12-12 16:04 ` Re: How to turnoff autovacuum Oleksandr Mazyar <drumenbassik@gmail.com>
@ 2020-12-12 16:15 ` David G. Johnston <david.g.johnston@gmail.com>
2020-12-12 17:07 ` Re: How to turnoff autovacuum Oleksandr Mazyar <drumenbassik@gmail.com>
1 sibling, 1 reply; 13+ messages in thread
From: David G. Johnston @ 2020-12-12 16:15 UTC (permalink / raw)
To: Oleksandr Mazyar <drumenbassik@gmail.com>; +Cc: Tim Cross <theophilusx@gmail.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
On Sat, Dec 12, 2020 at 9:05 AM Oleksandr Mazyar <drumenbassik@gmail.com>
wrote:
> What is it aurovacuum?
>
>>
>>
https://www.postgresql.org/docs/current/routine-vacuuming.html#AUTOVACUUM
David J.
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: How to turnoff autovacuum
2020-12-12 05:30 Fwd: How to turnoff autovacuum mark armon <1994hejian@gmail.com>
2020-12-12 15:26 ` Re: How to turnoff autovacuum Keith <keith@keithf4.com>
2020-12-12 15:38 ` Re: How to turnoff autovacuum Tim Cross <theophilusx@gmail.com>
2020-12-12 16:04 ` Re: How to turnoff autovacuum Oleksandr Mazyar <drumenbassik@gmail.com>
2020-12-12 16:15 ` Re: How to turnoff autovacuum David G. Johnston <david.g.johnston@gmail.com>
@ 2020-12-12 17:07 ` Oleksandr Mazyar <drumenbassik@gmail.com>
0 siblings, 0 replies; 13+ messages in thread
From: Oleksandr Mazyar @ 2020-12-12 17:07 UTC (permalink / raw)
To: David G. Johnston <David.G.Johnston@gmail.com>; +Cc: Tim Cross <theophilusx@gmail.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
I am not very good at this. I need help.
сб, 12 дек. 2020 г., 18:15 David G. Johnston <david.g.johnston@gmail.com>:
> On Sat, Dec 12, 2020 at 9:05 AM Oleksandr Mazyar <drumenbassik@gmail.com>
> wrote:
>
>> What is it aurovacuum?
>>
>>>
>>>
> https://www.postgresql.org/docs/current/routine-vacuuming.html#AUTOVACUUM
>
> David J.
>
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: How to turnoff autovacuum
2020-12-12 05:30 Fwd: How to turnoff autovacuum mark armon <1994hejian@gmail.com>
2020-12-12 15:26 ` Re: How to turnoff autovacuum Keith <keith@keithf4.com>
2020-12-12 15:38 ` Re: How to turnoff autovacuum Tim Cross <theophilusx@gmail.com>
2020-12-12 16:04 ` Re: How to turnoff autovacuum Oleksandr Mazyar <drumenbassik@gmail.com>
@ 2020-12-12 22:48 ` Tim Cross <theophilusx@gmail.com>
1 sibling, 0 replies; 13+ messages in thread
From: Tim Cross @ 2020-12-12 22:48 UTC (permalink / raw)
To: Oleksandr Mazyar <drumenbassik@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
Oleksandr Mazyar <drumenbassik@gmail.com> writes:
> What is it aurovacuum?
Obviously a typo - clue in the thread subject title
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: How to turnoff autovacuum
2020-12-12 05:30 Fwd: How to turnoff autovacuum mark armon <1994hejian@gmail.com>
2020-12-12 15:26 ` Re: How to turnoff autovacuum Keith <keith@keithf4.com>
@ 2020-12-13 04:27 ` mark armon <1994hejian@gmail.com>
2020-12-13 04:36 ` Re: How to turnoff autovacuum Wells Oliver <wells.oliver@gmail.com>
1 sibling, 1 reply; 13+ messages in thread
From: mark armon @ 2020-12-13 04:27 UTC (permalink / raw)
To: Keith <keith@keithf4.com>; +Cc: pgsql-admin
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@keithf4.com> wrote:
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?
Keith
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: How to turnoff autovacuum
2020-12-12 05:30 Fwd: How to turnoff autovacuum mark armon <1994hejian@gmail.com>
2020-12-12 15:26 ` Re: How to turnoff autovacuum Keith <keith@keithf4.com>
2020-12-13 04:27 ` Re: How to turnoff autovacuum mark armon <1994hejian@gmail.com>
@ 2020-12-13 04:36 ` Wells Oliver <wells.oliver@gmail.com>
2020-12-13 13:39 ` Re: How to turnoff autovacuum Scott Ribe <scott_ribe@elevated-dev.com>
0 siblings, 1 reply; 13+ messages in thread
From: Wells Oliver @ 2020-12-13 04:36 UTC (permalink / raw)
To: mark armon <1994hejian@gmail.com>; +Cc: Keith <keith@keithf4.com>; pgsql-admin
Friends don’t let friends turn off auto vacuum
On Sat, Dec 12, 2020 at 20:27 mark armon <1994hejian@gmail.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@keithf4.com> wrote:
>
>
>
>
> 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?
>
> Keith
>
> --
Wells Oliver
wells.oliver@gmail.com <wellsoliver@gmail.com>
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: How to turnoff autovacuum
2020-12-12 05:30 Fwd: How to turnoff autovacuum mark armon <1994hejian@gmail.com>
2020-12-12 15:26 ` Re: How to turnoff autovacuum Keith <keith@keithf4.com>
2020-12-13 04:27 ` Re: How to turnoff autovacuum mark armon <1994hejian@gmail.com>
2020-12-13 04:36 ` Re: How to turnoff autovacuum Wells Oliver <wells.oliver@gmail.com>
@ 2020-12-13 13:39 ` Scott Ribe <scott_ribe@elevated-dev.com>
0 siblings, 0 replies; 13+ messages in thread
From: Scott Ribe @ 2020-12-13 13:39 UTC (permalink / raw)
To: Wells Oliver <wells.oliver@gmail.com>; +Cc: mark armon <1994hejian@gmail.com>; Keith <keith@keithf4.com>; pgsql-admin
> On Dec 12, 2020, at 9:36 PM, Wells Oliver <wells.oliver@gmail.com> wrote:
>
> Friends don’t let friends turn off auto vacuum
Perhaps the point of turning it off in a tutorial is to make sure that the before/after can be observed
^ permalink raw reply [nested|flat] 13+ messages in thread
end of thread, other threads:[~2020-12-13 13:39 UTC | newest]
Thread overview: 13+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-12-12 05:30 Fwd: How to turnoff autovacuum mark armon <1994hejian@gmail.com>
2020-12-12 05:51 ` Amine Tengilimoglu <aminetengilimoglu@gmail.com>
2020-12-12 06:34 ` mark armon <1994hejian@gmail.com>
2020-12-12 06:39 ` Amine Tengilimoglu <aminetengilimoglu@gmail.com>
2020-12-12 15:26 ` Keith <keith@keithf4.com>
2020-12-12 15:38 ` Tim Cross <theophilusx@gmail.com>
2020-12-12 16:04 ` Oleksandr Mazyar <drumenbassik@gmail.com>
2020-12-12 16:15 ` David G. Johnston <david.g.johnston@gmail.com>
2020-12-12 17:07 ` Oleksandr Mazyar <drumenbassik@gmail.com>
2020-12-12 22:48 ` Tim Cross <theophilusx@gmail.com>
2020-12-13 04:27 ` mark armon <1994hejian@gmail.com>
2020-12-13 04:36 ` Wells Oliver <wells.oliver@gmail.com>
2020-12-13 13:39 ` Scott Ribe <scott_ribe@elevated-dev.com>
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