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 1iQW7Y-0005O4-Cx for pgsql-hackers@arkaria.postgresql.org; Fri, 01 Nov 2019 12:33:40 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iQW7X-0003qZ-6g for pgsql-hackers@arkaria.postgresql.org; Fri, 01 Nov 2019 12:33:39 +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 1iQW7W-0003qS-Qr for pgsql-hackers@lists.postgresql.org; Fri, 01 Nov 2019 12:33:38 +0000 Received: from out1-smtp.messagingengine.com ([66.111.4.25]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1iQW7T-0006JU-NH for pgsql-hackers@lists.postgresql.org; Fri, 01 Nov 2019 12:33:37 +0000 Received: from compute7.internal (compute7.nyi.internal [10.202.2.47]) by mailout.nyi.internal (Postfix) with ESMTP id 8587B21249; Fri, 1 Nov 2019 08:33:34 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute7.internal (MEProxy); Fri, 01 Nov 2019 08:33:34 -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:references :subject:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm1; bh=s/68RNmwXYZg9uHAp08jEl/1DYj4XuI3L4D389wHv HA=; b=PYy7T9edlAfayIcLmXOejZ1sWn8rfliLj+plNOJWM7gqCAYoSVx6u69cU SdGyb28Ompc09nvUTqb6AjDEWKFSXBOdrrXsFmtfHZZTdCWV+cc93qKv8UBj50TP 58xzIYvyQ6jYiYK0Tpy1ZbOMghyVV/8E30nymphu2GmqYnHRxPTrN8MD0lhZT81N rnQKYHIgxkhQM3zeOjxHlxA0WAPSVKQr6FabJmsd0nZsourOEHY/tqSORklKyXC3 5gIa3Ou94MQCh0oqg2+ufeiUan55NJC9qL6khA25ALh/RunzViLZg1o19Aujz/hl 5wMSyVIR7nGSEiS6iU2ti7+LDzcCg== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedufedruddtjedggedtucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepuffvfhfhohfkffgfgggjtgfgsehtkeertddtfeejnecuhfhrohhmpefrvght vghrucfgihhsvghnthhrrghuthcuoehpvghtvghrrdgvihhsvghnthhrrghuthesvdhnug hquhgrughrrghnthdrtghomheqnecuffhomhgrihhnpedvnhguqhhurggurhgrnhhtrdgt ohhmnecukfhppeelfedrvdegvddrudegjedrjeelnecurfgrrhgrmhepmhgrihhlfhhroh hmpehpvghtvghrrdgvihhsvghnthhrrghuthesvdhnughquhgrughrrghnthdrtghomhen ucevlhhushhtvghrufhiiigvpedt 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 1176F80059; Fri, 1 Nov 2019 08:33:32 -0400 (EDT) Subject: Re: pglz performance To: Andrey Borodin References: <469C9ED9-348C-4FE7-A7A7-B0FA671BEE4C@yandex-team.ru> <20190513071427.GB2273@paquier.xyz> <446036FB-EA13-4F18-B593-70EDE0A35366@yandex-team.ru> <2035A8B0-AB54-4ADB-BEFE-ADABEC7BDADF@yandex-team.ru> <7d2fca56-48de-e459-2102-4a59d5f6c704@owca.info> <6375726F-B5D9-4C3E-AB69-580A54921099@yandex-team.ru> <91C5B481-7D99-4FE3-B540-035008B00CF1@yandex-team.ru> <862cac5c-60f5-0fde-9451-8b294472c57d@2ndquadrant.com> <6d5eb102-87e5-9dc8-3cf0-dd218e65ab18@2ndquadrant.com> <3C62CD88-AEAC-4041-9BF3-ACCE70C3A5F8@yandex-team.ru> <04E4EC5C-B603-4EF8-88C3-EA5CB5A59066@yandex-team.ru> <1C96A33A-6064-41E8-8231-3EC9441F35EC@yandex-team.ru> Cc: Gasper Zejn , pgsql-hackers@lists.postgresql.org From: Peter Eisentraut Organization: 2ndQuadrant Message-ID: <3c2d92d0-e715-f9ed-e1a7-3c510ed65940@2ndquadrant.com> Date: Fri, 1 Nov 2019 13:33:32 +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: <1C96A33A-6064-41E8-8231-3EC9441F35EC@yandex-team.ru> Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2019-10-25 07:05, Andrey Borodin wrote: >> 21 окт. 2019 г., в 14:09, Andrey Borodin написал(а): >> >> With Silesian corpus pglz_decompress_hacked is actually decreasing performance on high-entropy data. >> Meanwhile pglz_decompress_hacked8 is still faster than usual pglz_decompress. >> In spite of this benchmarks, I think that pglz_decompress_hacked8 is safer option. > > Here's v3 which takes into account recent benchmarks with Silesian Corpus and have better comments. Your message from 21 October appears to say that this change makes the performance worse. So I don't know how to proceed with this. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services