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

List:       postgresql-admin
Subject:    Re: [BUGS] [ADMIN] Can postgres run autovacuum tasks when autovacuum is disabled?
From:       Andrey Zhidenkov <pensnarik () gmail ! com>
Date:       2014-07-31 5:56:13
Message-ID: CAN=gQ4B7HCeVc_D6eKNfnr8WN-7V35xbfdrowaf5fA_V_c5dGg () mail ! gmail ! com
[Download RAW message or body]

Thank you for your fix. It is really seems that this bug appears only when
some autovacuum jobs are active.

Andrey Zhidenkov.


On Wed, Jul 30, 2014 at 7:09 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> I wrote:
> > However ... it looks to me like if the autovac launcher gets launched
> > forcibly because of a possible wraparound issue, it will keep running
> > normally after that even if autovacuum is off :-(.
>
> Nope, scratch that: I missed the bit before the launcher's main loop,
> where it fires off one child and exits if it's launched when autovacuum
> is already false.
>
> Still, if it does fire one child process, it looks like that child will
> vacuum everything that seems to need vacuuming in the target database.
> We should probably adjust that so that tables not in danger of wraparound
> get skipped.
>
>                         regards, tom lane
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>



-- 
С уважением, Андрей Жиденков.

                       _
ASCII ribbon campaign ( )
 against HTML e-mail   X
                      / \

[Attachment #3 (text/html)]

<div dir="ltr">Thank you for your fix. It is really seems that this bug appears only \
when some autovacuum jobs are active.<div><br></div><div>Andrey \
Zhidenkov.</div></div><div class="gmail_extra"><br><br><div class="gmail_quote"> On \
Wed, Jul 30, 2014 at 7:09 PM, Tom Lane <span dir="ltr">&lt;<a \
href="mailto:tgl@sss.pgh.pa.us" target="_blank">tgl@sss.pgh.pa.us</a>&gt;</span> \
wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px \
#ccc solid;padding-left:1ex"> <div class="">I wrote:<br>
&gt; However ... it looks to me like if the autovac launcher gets launched<br>
&gt; forcibly because of a possible wraparound issue, it will keep running<br>
&gt; normally after that even if autovacuum is off :-(.<br>
<br>
</div>Nope, scratch that: I missed the bit before the launcher&#39;s main loop,<br>
where it fires off one child and exits if it&#39;s launched when autovacuum<br>
is already false.<br>
<br>
Still, if it does fire one child process, it looks like that child will<br>
vacuum everything that seems to need vacuuming in the target database.<br>
We should probably adjust that so that tables not in danger of wraparound<br>
get skipped.<br>
<div class="HOEnZb"><div class="h5"><br>
                                    regards, tom lane<br>
<br>
<br>
--<br>
Sent via pgsql-admin mailing list (<a \
href="mailto:pgsql-admin@postgresql.org">pgsql-admin@postgresql.org</a>)<br> To make \
changes to your subscription:<br> <a \
href="http://www.postgresql.org/mailpref/pgsql-admin" \
target="_blank">http://www.postgresql.org/mailpref/pgsql-admin</a><br> \
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br>С \
уважением, Андрей Жиденков.<br><br><pre><font>                 \
_<br>ASCII ribbon campaign ( )<br> against HTML e-mail   X<br>                      / \
\</font></pre>


</div>



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