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 1n9xaq-0002zF-5Q for pgsql-committers@arkaria.postgresql.org; Tue, 18 Jan 2022 23:08:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n9xao-0006M6-MQ for pgsql-committers@arkaria.postgresql.org; Tue, 18 Jan 2022 23:08:46 +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 1n9xam-0006Ls-T0 for pgsql-committers@lists.postgresql.org; Tue, 18 Jan 2022 23:08:46 +0000 Received: from wout2-smtp.messagingengine.com ([64.147.123.25]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1n9xak-0006xe-Hp for pgsql-committers@lists.postgresql.org; Tue, 18 Jan 2022 23:08:43 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailout.west.internal (Postfix) with ESMTP id 8DB6D3201DD2; Tue, 18 Jan 2022 18:08:40 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute1.internal (MEProxy); Tue, 18 Jan 2022 18:08:41 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=anarazel.de; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm3; bh=mO31P5JpXkjrkxNL3XOi70AM+1d swTMOOQefVX0gnFU=; b=ntnJoaKrnFDITq1z4uOJ9S5Rlqp0/dadUCNuaeiKrz9 8Il+oRG4K4MbjFT9BYb9kiAGlkX2Dln3A8x9JjT5SjsFoGmvo9ouufitTScHSxJ4 JC9Vm+R2+iHlZ6m8JUREQy8Hvqc7+DnlAD9+y8S7PLf7JPdQtrhx57wnkW6aum2/ +c62mJtWBtefP+X8IEtMG1UkVBUBQkBIvXV1CuBdAVy8fsxYopa1EXnYLhXM/0G0 ygX5H7uwqIPMO1WLT3Vl31vMnM8r+Gjzh32DXBBWAeCl48EiWTBDYQuBB+X0XoU2 rYWqJVMA/eBoOQPLXce1jbnbNdngQGkZUDTHlDorT0w== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; bh=mO31P5 JpXkjrkxNL3XOi70AM+1dswTMOOQefVX0gnFU=; b=lb7rgaj/AgN1PuRp3EPc35 dek76PISUAubNSpjLHuZEL7t8K0FS5K95CWF5XQNOEyds6sTN7pbXlmpC7khkJO/ XNYBVfboAGdeYS3UCHOGCEApNUS/IyjtbVsKuk/txTjfudhYbwJZPwWC4nilXP+X E6I0pOIG8pN0A4s//iPi9J8O2SwFZ1VlgH8vaj0VhclM+LLZjRegxj2sHychmlRD x0+WKUDLZQULbcxQCD0BfxslENdlq8ye/7yDalfncZ5mGZJ4GIjsaow3RUooEFgG 5QyJFq/uIeeX6AdgCJjpnTuWMJXRRQy0HFQXvxSENytKtcq3ttZ0RkxsYXXedm3w == X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvvddrudeggddtgecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenuc fjughrpeffhffvuffkfhggtggujgesthdtredttddtvdenucfhrhhomheptehnughrvghs ucfhrhgvuhhnugcuoegrnhgurhgvshesrghnrghrrgiivghlrdguvgeqnecuggftrfgrth htvghrnhepudekhfekleeugeevteehleffffejgeelueduleeffeeutdelffeujeffhfeu ffdunecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprg hnughrvghssegrnhgrrhgriigvlhdruggv X-ME-Proxy: Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 18 Jan 2022 18:08:39 -0500 (EST) Date: Tue, 18 Jan 2022 15:08:38 -0800 From: Andres Freund To: Tom Lane Cc: Thomas Munro , Michael Paquier , Thomas Munro , pgsql-committers Subject: Re: pgsql: Test replay of regression tests, attempt II. Message-ID: <20220118230838.amvazn2ig4cf56oy@alap3.anarazel.de> References: <20220117203746.oj43254j5jurbneu@alap3.anarazel.de> <374643.1642536944@sss.pgh.pa.us> <20220118204012.qpfas4fmvc55g4ei@alap3.anarazel.de> <415981.1642544346@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <415981.1642544346@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On 2022-01-18 17:19:06 -0500, Tom Lane wrote: > Andres Freund writes: > > That's an extremely small shared_buffers for running the regression tests, 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.) I ran the test in a loop for 200+ times now, without reproducing the problem. Rorqual runs on a shared machine though, so it's quite possible that IO will be slower, and thus triggering the issue. I was wondering whether we could use VACUUM VERBOSE for that specific VACUUM - that'd show information about the number of pages with tuples etc. But I don't currently see a way of that causing the regression tests to fail. Even if I set client_min_messages=error, the messages still get sent to the client, because elevel == INFO is special cased in should_output_to_client(). And I don't see a way of redirecting the output of common.c:NoticeProcessor() in psql either. Greetings, Andres Freund