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 ) id 1n9wox-0000j9-Bg for pgsql-committers@arkaria.postgresql.org; Tue, 18 Jan 2022 22:19:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n9wov-0004MC-Ts for pgsql-committers@arkaria.postgresql.org; Tue, 18 Jan 2022 22:19:17 +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 ) id 1n9wov-0004M2-Mt for pgsql-committers@lists.postgresql.org; Tue, 18 Jan 2022 22:19:17 +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 ) id 1n9wop-0006br-04 for pgsql-committers@lists.postgresql.org; Tue, 18 Jan 2022 22:19:16 +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 20IMJ66r415982; Tue, 18 Jan 2022 17:19:06 -0500 From: Tom Lane To: Andres Freund cc: Thomas Munro , Michael Paquier , Thomas Munro , pgsql-committers Subject: Re: pgsql: Test replay of regression tests, attempt II. In-reply-to: <20220118204012.qpfas4fmvc55g4ei@alap3.anarazel.de> References: <20220117203746.oj43254j5jurbneu@alap3.anarazel.de> <374643.1642536944@sss.pgh.pa.us> <20220118204012.qpfas4fmvc55g4ei@alap3.anarazel.de> Comments: In-reply-to Andres Freund message dated "Tue, 18 Jan 2022 12:40:12 -0800" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <415980.1642544346.1@sss.pgh.pa.us> Content-Transfer-Encoding: quoted-printable Date: Tue, 18 Jan 2022 17:19:06 -0500 Message-ID: <415981.1642544346@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Andres Freund writes: > That's an extremely small shared_buffers for running the regression test= s, it'd not > be surprising if that provoked problems we don't otherwise see. Perhaps = VACUUM > ends up skipping over a page because of page contention? Hmm, good thought. I tried running the test with even smaller shared_buffers, but could not make the reloptions test fall over for me. But this theory implies a strong timing dependency, so it might still only happen on particular machines. (If anyone else tries it: below about 400kB, other tests start failing with "no free unpinned buffers" and the like.) > Also, it's odd that there's "max_connections 25" without an equal sign. = I'd > kind of expected that to cause an error.... I see that guc.c intentionally allows the equal sign to be optional. Too lazy to check if that's documented. It is weird that this one test appears to be intentionally testing that, though, because it's sure got nada to do with the expressed purpose of the test. regards, tom lane