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 1lUJoW-0003F8-A1 for pgsql-committers@arkaria.postgresql.org; Thu, 08 Apr 2021 01:50:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lUJoU-0005Zf-Vg for pgsql-committers@arkaria.postgresql.org; Thu, 08 Apr 2021 01:50:30 +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 1lUJoT-0005TE-EN for pgsql-committers@lists.postgresql.org; Thu, 08 Apr 2021 01:50:30 +0000 Received: from wout5-smtp.messagingengine.com ([64.147.123.21]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lUJoM-0007u4-RW for pgsql-committers@lists.postgresql.org; Thu, 08 Apr 2021 01:50:28 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailout.west.internal (Postfix) with ESMTP id CFE3913CE; Wed, 7 Apr 2021 21:50:20 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute1.internal (MEProxy); Wed, 07 Apr 2021 21:50:21 -0400 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=fm1; bh=XUu3T6RF5h6/1UP6PnZ+EMmpAbl 9Wu0Y2zSf9Gr+eqU=; b=m2yR4aH7m+yVXRVwJETtKauYiuh/iK7HGIb7RdCW70T /jPT2u/RJg14gnm/T0G4jMaQHN4T6t/lR6dW1M9PMWtXNjMsjtCtZUtAjZF6ymVe HBbiVB6URwi5N2JEInNnP8eULWZ1MqD9xp4EqOaQ7dwMloqHKrmJDiSpavosB/QX mvoLUspSBvBd6vBkdq013IyB3XbgRzLIe7ymbT0sK0T26VVAFCSmCaBSp0HXn6m8 MVArm0U5uVpq8VDoNZTUtYPxCxI4fIKvDGAas0jh7t6LoeSRni6HubAHoWpuA5Px SzUrxNPTHrK6ImGgObKgJLigczTPS4M+cegqK0KGobg== 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=fm2; bh=XUu3T6 RF5h6/1UP6PnZ+EMmpAbl9Wu0Y2zSf9Gr+eqU=; b=UCuDIRZsqmYNpGr4x3caa6 P5ntFDHN/jHUBaAt/TZsxKJGmNzaJ7EXPLYkd9EZkRvmcBVZElF3nDzFngMi+p18 EhOX2V3ZDOWkWzHvdhSYCm7ZkJAV8a8bjo9oZj5f5T63BGXTmMVEiII9usl8j/+/ PKXDnaV3CLSSjxUaaL9IfBoHtSayX/Rb7V8tcLfoJUDI+KiM7HraCYhb11baLRyS /51fODxVumOtzhZg9UpTkEjWK60eEKRmE2VMpPcL/S3grjCbu9TGcqYiwGo2jfzT 9bSGJ4EljgZ7bgdbpL5Eg+NV+lzxO9smSLEOIXckUfqrU5tshBxh+TSdhk01Nqmg == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduledrudejkedghedvucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepfffhvffukfhfgggtuggjsehttdertddttddvnecuhfhrohhmpeetnhgurhgv shcuhfhrvghunhguuceorghnughrvghssegrnhgrrhgriigvlhdruggvqeenucggtffrrg htthgvrhhnpedukefhkeelueegveetheelffffjeegleeuudelfeefuedtleffueejfffh ueffudenucfkphepuddtjedrudegvddrfeefrddutdefnecuvehluhhsthgvrhfuihiivg eptdenucfrrghrrghmpehmrghilhhfrhhomheprghnughrvghssegrnhgrrhgriigvlhdr uggv X-ME-Proxy: Received: from intern.anarazel.de (107-142-33-103.lightspeed.sntcca.sbcglobal.net [107.142.33.103]) by mail.messagingengine.com (Postfix) with ESMTPA id B330F1080054; Wed, 7 Apr 2021 21:50:19 -0400 (EDT) Date: Wed, 7 Apr 2021 18:50:17 -0700 From: Andres Freund To: David Rowley Cc: Tom Lane , Peter Eisentraut , pgsql-committers@lists.postgresql.org Subject: Re: pgsql: SQL-standard function body Message-ID: <20210408015017.yb2tb324y6zt4o66@alap3.anarazel.de> References: <20210407225806.majgznh4lk34hjvu@alap3.anarazel.de> <1730972.1617836766@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On 2021-04-08 13:33:18 +1200, David Rowley wrote: > On Thu, 8 Apr 2021 at 11:06, Tom Lane wrote: > > > > Andres Freund writes: > > > > > Might be force_parallel_mode=regress related. > > > > Yeah. On my machine, it's fine without force_parallel_mode and > > crashes with that. Looks like query text is not getting passed > > to the parallel worker in some cases. > > I wonder if it would be worth adding a regression test run of the core > tests during make check-world with force_parallel_mode set to regress. > > But maybe people running the tests on slow machines might not be a fan > of that idea. I've wondered about that too. Perhaps we could reuse the pg_upgrade run? Greetings, Andres Freund