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

List:       pgsql-performance
Subject:    Re: AutoVacuum and growing transaction XID's
From:       github kran <githubkran () gmail ! com>
Date:       2020-05-12 15:40:25
Message-ID: CACaZr5T4P8oo45gvqOKn8CrAatGr-POW0=jpHzEXZ4zn5U3mCA () mail ! gmail ! com
[Download RAW message or body]

Thanks for yous suggestions Michael  and David.

On Fri, May 8, 2020 at 4:11 PM Michael Lewis <mlewis@entrata.com> wrote:

> autovacuum_naptime being only 5 seconds seems too frequent. A lock_timeout
> might be 1-5 seconds depending on your system. Usually, DDL can fail and
> wait a little time rather than lock the table for minutes and have all
> reads back up behind the DDL.
>
> Given you have autovacuum_vacuum_cost_limit set to unlimited (seems very
> odd), I'm not sure a manual vacuum freeze command on the tables with high
> age would perform differently. Still, issuing a vacuum freeze and then
> killing the autovacuum process might be worth trying.
>

[Attachment #3 (text/html)]

<div dir="ltr"><div dir="ltr">Thanks for yous suggestions Michael   and \
David.<br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On \
Fri, May 8, 2020 at 4:11 PM Michael Lewis &lt;<a \
href="mailto:mlewis@entrata.com">mlewis@entrata.com</a>&gt; \
wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div \
dir="ltr">autovacuum_naptime being only 5 seconds seems too frequent. A lock_timeout \
might be 1-5 seconds depending on your system. Usually, DDL can fail and wait a \
little time rather than lock the table for minutes and have all reads back up behind \
the DDL.<div><br></div><div>Given you have  autovacuum_vacuum_cost_limit set to \
unlimited (seems very odd), I&#39;m not sure a manual vacuum freeze command on the \
tables with high age would perform differently. Still, issuing a vacuum freeze and \
then killing the autovacuum process might be worth trying.</div></div></div> \
</blockquote></div></div>



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