Re: autovacuum locking question

--00000000000007af1a0598fcbf18
Content-Type: text/plain; charset="UTF-8"

On Thu, Dec 5, 2019 at 3:26 PM Mike Schanne <[email protected]> wrote:

> I am concerned that if the autovacuum is constantly canceled, then the
> table never gets cleaned and its performance will continue to degrade over
> time.  Is it expected for the vacuum to be canceled by an insert in this
> way?
>
>
>
> We are using postgres 9.6.10.
>

Have you checked when the table was last autovacuumed in
pg_stat_user_tables? If the autovacuum count is high and timestamp of last
run is relatively current, then no reason for concern as far as I can
figure.

Have you already configured (non-default values) for autovacuum options for
your system or this table?

--00000000000007af1a0598fcbf18
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Thu, Dec 5, 2019 at 3:26 PM Mike Schan=
ne &lt;<a href=3D"mailto:[email protected]">[email protected]</a>&gt; wrote:<=
br></div><div class=3D"gmail_quote"><blockquote class=3D"gmail_quote" style=
=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding=
-left:1ex">





<div lang=3D"EN-US">
<div class=3D"gmail-m_751046425130706357WordSection1">
<p class=3D"MsoNormal">I am concerned that if the autovacuum is constantly =
canceled, then the table never gets cleaned and its performance will contin=
ue to degrade over time.=C2=A0 Is it expected for the vacuum to be canceled=
 by an insert in this way?</p><p class=3D"MsoNormal"><u></u></p>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
<p class=3D"MsoNormal">We are using postgres 9.6.10.</p></div></div></block=
quote><div><br></div><div>Have you checked when the table was last autovacu=
umed in pg_stat_user_tables? If the autovacuum count is high and timestamp =
of last run is relatively current, then no reason for concern as far as I c=
an figure.</div><div><br></div><div>Have you already configured (non-defaul=
t values) for autovacuum options for your system or this table?</div></div>=
</div>

--00000000000007af1a0598fcbf18--