From: Tom Lane <tgl@sss.pgh.pa.us>
To: John Naylor <john.naylor@enterprisedb.com>
cc: Daniel Gustafsson <daniel@yesql.se>,
        Masahiko Sawada <sawada.mshk@gmail.com>,
        Heikki Linnakangas <hlinnaka@iki.fi>,
        Ian Lawrence Barwick <barwick@gmail.com>,
        Andres Freund <andres@anarazel.de>,
        Anastasia Lubennikova <lubennikovaav@gmail.com>,
        PostgreSQL Hackers <pgsql-hackers@postgresql.org>,
        Peter Geoghegan <pg@bowt.ie>
Subject: Re: Testing autovacuum wraparound (including failsafe)
In-reply-to: <CAFBsxsEAJT5JpUtdWdpE53xkKA+trnJ4eyPZKggLbUBtaXMUeg@mail.gmail.com>
References: <20210423204306.5osfpkt2ggaedyvy@alap3.anarazel.de> <CAP4vRV5gEHFLB7NwOE6_dyHAeVfkvqF8Z_g5GaCQZNgBAE0Frw@mail.gmail.com> <20210611011850.detxnd7bnffg3daz@alap3.anarazel.de> <CAD21AoC-xMv1pModWvUQ1g1qByxMmu6yLghsKVb-R35rmShiwA@mail.gmail.com> <CAD21AoDVhkXp8HjpFO-gp3TgL6tCKcZQNxn04m01VAtcSi-5sA@mail.gmail.com> <CAB8KJ=j1b3kscX8Cg5G=Q39ZQsv2x4URXsuTueJLz=fcvJ3eoQ@mail.gmail.com> <64524348-b10e-9904-4858-8fe62d058b14@iki.fi> <CAD21AoDouzPRqhZJWpoXje=MPFUx8kM3SGa2MkrRtsjzJSrSpQ@mail.gmail.com> <CAD21AoAyYBZOiB1UPCPZJHTLk0-arrq5zqNGj+PrsbpdUy=g-g@mail.gmail.com> <CAFBsxsGAh23p5ny9sHRf6UB9ve6KAb95Hi5e4NdkqPEEZDrOaQ@mail.gmail.com> <CAD21AoBZ3t+fRtVamQTA+wBJaapFUY1dfP08-rxsQ+fouPvgKg@mail.gmail.com> <86FBC46E-9192-45AB-B0D8-6118747B7185@yesql.se> <CAFBsxsEAJT5JpUtdWdpE53xkKA+trnJ4eyPZKggLbUBtaXMUeg@mail.gmail.com>
Comments: In-reply-to John Naylor <john.naylor@enterprisedb.com>
	message dated "Fri, 28 Apr 2023 10:21:24 +0700"
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-ID: <1271926.1682656943.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Fri, 28 Apr 2023 00:42:23 -0400
Message-ID: <1271927.1682656943@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/1271927.1682656943%40sss.pgh.pa.us>
Precedence: bulk

John Naylor <john.naylor@enterprisedb.com> writes:
> On Thu, Apr 27, 2023 at 9:12=E2=80=AFPM Daniel Gustafsson <daniel@yesql.=
se> wrote:
>> Is there a risk that the background psql will time out on slow systems =
during
>> the consumption of 2B xid's?  Since you mainly want to hold it open for=
 the
>> duration of testing you might want to bump it to avoid false negatives =
on
>> slow test systems.

> If they're that slow, I'd worry more about generating 20GB of xact statu=
s
> data. That's why the tests are disabled by default.

There is exactly zero chance that anyone will accept the introduction
of such an expensive test into either check-world or the buildfarm
sequence.

			regards, tom lane