pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
To: Andrey Borodin <x4mmm@yandex-team.ru>
Cc: Gasper Zejn <zejn@owca.info>
Cc: pgsql-hackers@lists.postgresql.org
Subject: Re: pglz performance
Date: Fri, 1 Nov 2019 13:33:32 +0100
Message-ID: <3c2d92d0-e715-f9ed-e1a7-3c510ed65940@2ndquadrant.com> (raw)
In-Reply-To: <1C96A33A-6064-41E8-8231-3EC9441F35EC@yandex-team.ru>
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>
	<c9af20cf-26e0-092c-910e-700fbd563f44@2ndquadrant.com>
	<B297A106-FFB1-4B5D-9D9A-6FFBAB16A279@yandex-team.ru>
	<862cac5c-60f5-0fde-9451-8b294472c57d@2ndquadrant.com>
	<E9738D6F-F7C9-4DCF-9DE3-AC572A971953@yandex-team.ru>
	<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>

On 2019-10-25 07:05, Andrey Borodin wrote:
>> 21 окт. 2019 г., в 14:09, Andrey Borodin <x4mmm@yandex-team.ru> написал(а):
>>
>> 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





view thread (70+ messages)  latest in thread

Message-ID: <3c2d92d0-e715-f9ed-e1a7-3c510ed65940@2ndquadrant.com>
Permalink:  ../3c2d92d0-e715-f9ed-e1a7-3c510ed65940@2ndquadrant.com/
Also on:    postgresql.org/message-id/3c2d92d0-e715-f9ed-e1a7-3c510ed65940@2ndquadrant.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: peter.eisentraut@2ndquadrant.com, x4mmm@yandex-team.ru, zejn@owca.info, pgsql-hackers@lists.postgresql.org
  Subject: Re: pglz performance
  In-Reply-To: <3c2d92d0-e715-f9ed-e1a7-3c510ed65940@2ndquadrant.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox