RE: Extremely slow autovacuum:vacuum to prevent wraparound
От | Rijo Roy |
---|---|
Тема | RE: Extremely slow autovacuum:vacuum to prevent wraparound |
Дата | |
Msg-id | 1890633047.2652525.1531318955319@mail.yahoo.com обсуждение исходный текст |
Ответ на | RE: Extremely slow autovacuum:vacuum to prevent wraparound (Steven Winfield <Steven.Winfield@cantabcapital.com>) |
Список | pgsql-general |
On Wed, 11 Jul 2018 at 7:50 pm, Steven Winfield<Steven.Winfield@cantabcapital.com> wrote:#yiv8600935552 #yiv8600935552 --_filtered #yiv8600935552 {panose-1:2 2 6 9 4 2 5 8 3 4;}_filtered #yiv8600935552 {panose-1:2 2 6 9 4 2 5 8 3 4;}_filtered #yiv8600935552 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}_filtered #yiv8600935552 {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;}_filtered #yiv8600935552 {panose-1:2 2 6 9 4 2 5 8 3 4;}_filtered #yiv8600935552 {font-family:New;panose-1:0 0 0 0 0 0 0 0 0 0;} #yiv8600935552 #yiv8600935552 p.yiv8600935552MsoNormal, #yiv8600935552 li.yiv8600935552MsoNormal, #yiv8600935552 div.yiv8600935552MsoNormal{margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;font-family:New;} #yiv8600935552 a:link, #yiv8600935552 span.yiv8600935552MsoHyperlink{color:blue;text-decoration:underline;} #yiv8600935552 a:visited, #yiv8600935552 span.yiv8600935552MsoHyperlinkFollowed{color:purple;text-decoration:underline;} #yiv8600935552 p.yiv8600935552msonormal, #yiv8600935552 li.yiv8600935552msonormal, #yiv8600935552 div.yiv8600935552msonormal{margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:New;} #yiv8600935552 span.yiv8600935552msohyperlink{} #yiv8600935552 span.yiv8600935552msohyperlinkfollowed{} #yiv8600935552 span.yiv8600935552emailstyle17{} #yiv8600935552 p.yiv8600935552msonormal1, #yiv8600935552 li.yiv8600935552msonormal1, #yiv8600935552 div.yiv8600935552msonormal1{margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;} #yiv8600935552 span.yiv8600935552msohyperlink1{color:blue;text-decoration:underline;} #yiv8600935552 span.yiv8600935552msohyperlinkfollowed1{color:purple;text-decoration:underline;} #yiv8600935552 span.yiv8600935552emailstyle171{color:#1F497D;} #yiv8600935552 span.yiv8600935552EmailStyle25{color:#1F497D;} #yiv8600935552 .yiv8600935552MsoChpDefault{}_filtered #yiv8600935552 {margin:72.0pt 72.0pt 72.0pt 72.0pt;} #yiv8600935552 div.yiv8600935552WordSection1{} #yiv8600935552 From: Rijo Roy [mailto:rjo_roy@yahoo.com]
Sent: 11 July 2018 15:14
To: Steven Winfield
Cc: pgsql-general@postgresql.org
Subject: RE: Extremely slow autovacuum:vacuum to prevent wraparound
Hi Steve,
Apologies, I misread it as 2 billion, it is as you said set as 200 million which is the default value for the parameter autovacuum_freeze_max_age.
I just wanted to confirm whether there would be any impact if I cancel or terminate the backend for the existing autovacuum :vacuum table_name (to prevent wraparound). I have initiated a normal vacuum manually but it is stuck on the table where the autovacuum is processing it.
Thanks,
Rijo Roy
Stack Overflow confirms my memories about killing autovacuum - pg_cancel_backend() should be fine.
Steve.
This email is confidential. If you are not the intended recipient, please advise us immediately and delete this message. The registered name of Cantab- part of GAM Systematic is Cantab Capital Partners LLP. See - http://www.gam.com/en/Legal/Email+disclosures+EU for further information on confidentiality, the risks of non-secure electronic communication, and certain disclosures which we are required to make in accordance with applicable legislation and regulations. If you cannot access this link, please notify us by reply message and we will send the contents to you.
GAM Holding AG and its subsidiaries (Cantab – GAM Systematic) will collect and use information about you in the course of your interactions with us. Full details about the data types we collect and what we use this for and your related rights is set out in our online privacy policy at https://www.gam.com/en/legal/privacy-policy. Please familiarise yourself with this policy and check it from time to time for updates as it supplements this notice
В списке pgsql-general по дате отправления:
Предыдущее
От: Steven WinfieldДата:
Сообщение: RE: Extremely slow autovacuum:vacuum to prevent wraparound