Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1nF57R-0007DX-15
	for pgsql-hackers@arkaria.postgresql.org; Wed, 02 Feb 2022 02:11:37 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1nF57O-0002t1-Au
	for pgsql-hackers@arkaria.postgresql.org; Wed, 02 Feb 2022 02:11:34 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1nF57O-0002ss-1g
	for pgsql-hackers@lists.postgresql.org; Wed, 02 Feb 2022 02:11:34 +0000
Received: from sss.pgh.pa.us ([66.207.139.130])
	by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1nF57K-0005YQ-I7
	for pgsql-hackers@postgresql.org; Wed, 02 Feb 2022 02:11:32 +0000
Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1])
	by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 2122BOTj1046819;
	Tue, 1 Feb 2022 21:11:24 -0500
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Thomas Munro <thomas.munro@gmail.com>
cc: Andres Freund <andres@anarazel.de>, Michael Paquier <michael@paquier.xyz>,
        Andrew Dunstan <andrew@dunslane.net>,
        Anastasia Lubennikova <lubennikovaav@gmail.com>,
        pgsql-hackers <pgsql-hackers@postgresql.org>
Subject: Re: A test for replay of regression tests
In-reply-to: 
 <CA+hUKGK6mG8-6VieDm3sz2yzqMqw7j_=ag=_XmKLKsS-hG6KQw@mail.gmail.com>
References: <YbmsZbEO1QGMymNF@paquier.xyz> <YbqG0DsKGRBnY/4t@paquier.xyz>
 <CA+hUKGK-+mg6RWiDu0JudF6jWeL5+gPmi8EKUm1eAzmdbwiE_A@mail.gmail.com>
 <CA+hUKG+GBC-6QhOKt6Y7ccrXSjbRHB7Di295=0rAGhE7a7hSrQ@mail.gmail.com>
 <CA+hUKGLneD+q+E7upHGwn41KGvbxhsKbJ+M-y9nvv7_Xjv8Qog@mail.gmail.com>
 <20220114234947.av4kkhuj7netsy5r@alap3.anarazel.de>
 <CA+hUKG+yxxnFWvp4h_HgJvptQ2uKE4aKtDd7e5nmr61Soe6a2Q@mail.gmail.com>
 <20220121194827.7eau4ulhrfol3npd@alap3.anarazel.de>
 <CA+hUKGK65xVqNgsSPyrr2LEwtfUN=GfEuQ868hTC-mu0bFG42A@mail.gmail.com>
 <CA+hUKG+1=MpM2aXOHhXE9myBqMsgV4N0fOTgCqubZZ_mXgRuQg@mail.gmail.com>
 <20220202011402.e7t3hu3jusalr32h@alap3.anarazel.de>
 <CA+hUKGK6mG8-6VieDm3sz2yzqMqw7j_=ag=_XmKLKsS-hG6KQw@mail.gmail.com>
Comments: In-reply-to Thomas Munro <thomas.munro@gmail.com>
	message dated "Wed, 02 Feb 2022 14:35:02 +1300"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1046817.1643767884.1@sss.pgh.pa.us>
Date: Tue, 01 Feb 2022 21:11:24 -0500
Message-ID: <1046818.1643767884@sss.pgh.pa.us>
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: 
 <https://www.postgresql.org/message-id/1046818.1643767884%40sss.pgh.pa.us>
Precedence: bulk

Thomas Munro <thomas.munro@gmail.com> writes:
> It looks like it's processing statements fairly consistently slowly
> through the whole period.   Each non-trivial statement takes a bit
> under ~10ms, so it would make sense if by the time we've processed
> ~2.5k lines we've clocked up 30 seconds and a VACUUM replay whacks us.

This test is set up to time out after 30 seconds?  We've long had
an unofficial baseline that no timeouts under 180 seconds should
be used in the buildfarm.

			regards, tom lane