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 1m6cwQ-00085b-RO for pgsql-performance@arkaria.postgresql.org; Thu, 22 Jul 2021 17:57:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m6cwP-0007WG-OZ for pgsql-performance@arkaria.postgresql.org; Thu, 22 Jul 2021 17:57:01 +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 1m6cwP-0007VV-GO for pgsql-performance@lists.postgresql.org; Thu, 22 Jul 2021 17:57:01 +0000 Received: from out1-smtp.messagingengine.com ([66.111.4.25]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m6cwN-0001br-Bo for pgsql-performance@postgresql.org; Thu, 22 Jul 2021 17:57:00 +0000 Received: from compute6.internal (compute6.nyi.internal [10.202.2.46]) by mailout.nyi.internal (Postfix) with ESMTP id 908B45C0181; Thu, 22 Jul 2021 13:56:58 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute6.internal (MEProxy); Thu, 22 Jul 2021 13:56:58 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:subject:to :x-me-proxy:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s= fm3; bh=2Yf65V7OBaXBueweXvpMKZ3Yp2yqdplBEiIBygBNc7Y=; b=g3DfFub6 sNK0OqWcOWEZ6BMhdhA9guhNL9cgIKQGdLoKXbeRGIcj3yhfSghu5LKpdxqU4/Uq bJ+4eo9Rz5DhSsCEA8X8N1xg6DEgFfoX+mkC5ypr1lRD/lIbVQAe8Bo8vQQ3/Onf GcQn3qYn8KDl09ZV+IdELHfktv9ID/fU8/tHxtlXK5Lp3/Gcrxy9q8f2sXXqXNTc 1Ql1CDCc0HuMtPFqdMf48QsK3fiD/tPDhWUB3WN9xowXSI2F3BnOqlekwyFDhsrW V1Z3HGRHMyJhGF6BwVk0RmwI/6KtYG/ARZZE1inADJqxu3LdVL0GEjCUAQv2u/HT kHotqwFc7BdNRw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvtddrfeeigddutdelucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepfffhvffukfggtggugfgjsehtkeertddttdejnecuhfhrohhmpeetlhhvrghr ohcujfgvrhhrvghrrgcuoegrlhhvhhgvrhhrvgesrghlvhhhrdhnohdqihhprdhorhhgqe enucggtffrrghtthgvrhhnpedujeevjeffjeevuddutedvkeeiueeitddvieelfeekveej udefgeeuvdejhfeuleenucffohhmrghinhepvghnthgvrhhprhhishgvuggsrdgtohhmne cuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprghlvhhh vghrrhgvsegrlhhvhhdrnhhoqdhiphdrohhrgh X-ME-Proxy: Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 22 Jul 2021 13:56:57 -0400 (EDT) Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 8D95E2A09B6; Thu, 22 Jul 2021 13:56:54 -0400 (-04) Date: Thu, 22 Jul 2021 13:56:54 -0400 From: Alvaro Herrera To: "ldh@laurent-hasson.com" Cc: Peter Geoghegan , Justin Pryzby , Tom Lane , David Rowley , "pgsql-performance@postgresql.org" Subject: Re: Big performance slowdown from 11.2 to 13.3 Message-ID: <202107221756.opvnumaebyht@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2021-Jul-22, ldh@laurent-hasson.com wrote: > Yes, agreed Peter... The "lower priority" issue was mentioned, but not > in terms of the applicability of the fix overall. Personally, I would > prefer going the size_t route vs int/long/int64 in C/C++/. Of course, > as a user, I'd love a patch on V13 and something cleaner in V14. Just to clarify our terminology here. "A patch" means any kind of change to the source code, regardless of its cleanliness or applicability to versions deemed stable. You can have one patch which is a ugly hack for a stable version that can't have invasive changes, and another patch which is a clean, more maintainable version of a totally different fix for the version in development. We use the same word, "patch", for both types of source code changes. -- Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/