[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-performance
Subject:    Re: autovacuum locking question
From:       Jeff Janes <jeff.janes () gmail ! com>
Date:       2019-12-07 0:59:00
Message-ID: CAMkU=1xxTrCBUUXM2KtJPa0sk4ZgZUsxHo52SdqVXR-=VU2Dtw () mail ! gmail ! com
[Download RAW message or body]

On Fri, Dec 6, 2019 at 12:50 PM MichaelDBA <MichaelDBA@sqlexec.com> wrote:

> And Just to reiterate my own understanding of this...
>
> autovacuum priority is less than a user-initiated request, so issuing a
> manual vacuum (user-initiated request) will not result in being cancelled.
>

Somethings happen in some situations and not in others.  I don't know that
it is useful to categorize them into a monotonic priority scale.

Autovacs "to prevent wraparound" don't get cancelled the way ordinary
autovacs do, but they still use autovac IO throttling settings, not the
unthrottled (by default settings) manual vacuum settings, which can be a
major problem sometimes.

Note that no kind of vacuum should normally get cancelled using the
signalling mechanism during truncation phase, that seems to be due to some
rather extreme situation with IO congestion.

Cheers,

Jeff

[Attachment #3 (text/html)]

<div dir="ltr"><div dir="ltr">On Fri, Dec 6, 2019 at 12:50 PM MichaelDBA &lt;<a \
href="mailto:MichaelDBA@sqlexec.com">MichaelDBA@sqlexec.com</a>&gt; \
wrote:<br></div><div class="gmail_quote"><blockquote class="gmail_quote" \
style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex">

<div>And Just to reiterate my own understanding 
of this...<br>
<br>
autovacuum priority is less than a user-initiated request, so issuing a 
manual vacuum (user-initiated request) will not result in being 
cancelled.<br></div></blockquote><div><br></div><div>Somethings  happen in some \
situations and not in others.   I don&#39;t know that it is useful to categorize them \
into a monotonic priority scale.</div><div><br></div><div>Autovacs &quot;to prevent \
wraparound&quot; don&#39;t get cancelled the way ordinary autovacs do, but they still \
use autovac IO throttling settings, not the unthrottled (by default settings) manual \
vacuum settings, which can be a major problem \
sometimes.</div><div><br></div><div>Note that no kind of vacuum should normally get \
cancelled using the signalling mechanism during truncation phase, that seems to be \
due to some rather extreme situation with IO \
congestion.</div><div><br></div><div>Cheers,</div><div><br></div><div>Jeff</div></div></div>




[prev in list] [next in list] [prev in thread] [next in thread]