Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iSGIr-0004wP-Bu for pgsql-hackers@arkaria.postgresql.org; Wed, 06 Nov 2019 08:04:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iSGIq-0005cC-5f for pgsql-hackers@arkaria.postgresql.org; Wed, 06 Nov 2019 08:04:32 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iSGIp-0005c5-Q0 for pgsql-hackers@lists.postgresql.org; Wed, 06 Nov 2019 08:04:31 +0000 Received: from wout3-smtp.messagingengine.com ([64.147.123.19]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1iSGIn-0003wE-Au for pgsql-hackers@lists.postgresql.org; Wed, 06 Nov 2019 08:04:30 +0000 Received: from compute7.internal (compute7.nyi.internal [10.202.2.47]) by mailout.west.internal (Postfix) with ESMTP id 22537426; Wed, 6 Nov 2019 03:04:28 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute7.internal (MEProxy); Wed, 06 Nov 2019 03:04:28 -0500 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:references :subject:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm1; bh=ELHAntdmZt+1OZiQrSMbPUeeMYSx9GqsFQniLo6J8 VU=; b=x00yrIY5ZHmBi+s7+xARUGtWFAq5j6yKDELYVL567SasJWKaMYVV15xOj 3TDcjIMbrhyogN0bpVvTmzPzy7CPlGwyV4d6PrV0WLc8R7C1V8EjHDG0tJUBXkH3 J2BhfPr9S7WbzfU1JJ1yZXagtcLMju4oqtURGtuag0eQGs7zcvP3tnwXbQjmj5ZM Y+H29y78poIlt/61Md9x/BVb6fkFvxRwC6/TrAeqoVjkOGHHGNfYBmDVlNbW14yf 9uAa5+xpQjbg75prjsPZ+YGPvN+eGr/ta2QCI80Nn+HIOcw7DMBDXBOc8eD8sdHY nyGTOQKYuSkj2nL6l09EHf37PrqOg== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedufedrudduiedgudduhecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfgh necuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmd enucfjughrpefuvfhfhfhokffffgggjggtgfesthejredttdefjeenucfhrhhomheprfgv thgvrhcugfhishgvnhhtrhgruhhtuceophgvthgvrhdrvghishgvnhhtrhgruhhtsedvnh guqhhurggurhgrnhhtrdgtohhmqeenucffohhmrghinhepvdhnughquhgrughrrghnthdr tghomhenucfkphepleefrddvgedvrddugeejrdejleenucfrrghrrghmpehmrghilhhfrh homhepphgvthgvrhdrvghishgvnhhtrhgruhhtsedvnhguqhhurggurhgrnhhtrdgtohhm necuvehluhhsthgvrhfuihiivgepud X-ME-Proxy: Received: from april.pezone.net (p5df2934f.dip0.t-ipconnect.de [93.242.147.79]) by mail.messagingengine.com (Postfix) with ESMTPA id A1CF18005A; Wed, 6 Nov 2019 03:04:26 -0500 (EST) Subject: Re: pglz performance To: Tomas Vondra , Alvaro Herrera References: <3c2d92d0-e715-f9ed-e1a7-3c510ed65940@2ndquadrant.com> <20191101154828.GA15829@alvherre.pgsql> <20191101165950.b5azncggaqfan5fi@development> Cc: Andrey Borodin , Gasper Zejn , pgsql-hackers@lists.postgresql.org From: Peter Eisentraut Organization: 2ndQuadrant Message-ID: <35c2a448-06b8-eab0-05ea-34a3f51ba9a8@2ndquadrant.com> Date: Wed, 6 Nov 2019 09:04:25 +0100 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:52.0) Gecko/20100101 Thunderbird/52.9.1 MIME-Version: 1.0 In-Reply-To: <20191101165950.b5azncggaqfan5fi@development> Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2019-11-01 17:59, Tomas Vondra wrote: > I'd try running the benchmarks to verify the numbers, and maybe do some > additional tests, but it's not clear to me which patches should I use. > > I think the last patches with 'hacked' and 'hacked8' in the name are a > couple of months old, and the recent posts attach just a single patch. > Andrey, can you post current versions of both patches? OK, waiting on some independent verification of benchmark numbers. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services