pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tomas Vondra <tomas.vondra@2ndquadrant.com>
To: Andres Freund <andres@anarazel.de>
Cc: Andrey Borodin <x4mmm@yandex-team.ru>
Cc: Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Cc: Michael Paquier <michael@paquier.xyz>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Cc: Vladimir Leskov <vladimirlesk@yandex-team.ru>
Subject: Re: pglz performance
Date: Fri, 2 Aug 2019 21:48:59 +0200
Message-ID: <20190802194859.qxzxq2achzottkup@development> (raw)
In-Reply-To: <20190802182003.u477q6itwudieqxf@alap3.anarazel.de>
References: <20190513071427.GB2273@paquier.xyz>
	<169163A8-C96F-4DBE-A062-7D1CECBE9E5D@yandex-team.ru>
	<ea57b49a-ecf0-481a-a77b-631833354f7d@postgrespro.ru>
	<20190802144345.d62jtiyyx6r2y73f@development>
	<DBB2A9E5-29FD-40BF-AC60-BD990FBF142F@yandex-team.ru>
	<20190802163948.i6mjypdgujeorrbi@alap3.anarazel.de>
	<20190802170039.o4pabnzm4xy3z7uj@development>
	<20190802171258.nob5zo2vu7siqo2b@alap3.anarazel.de>
	<20190802175239.5ds6rhdso6hwy4vk@development>
	<20190802182003.u477q6itwudieqxf@alap3.anarazel.de>

On Fri, Aug 02, 2019 at 11:20:03AM -0700, Andres Freund wrote:
>Hi,
>
>On 2019-08-02 19:52:39 +0200, Tomas Vondra wrote:
>> Hmmm, I don't remember the details of those patches so I didn't realize
>> it allows incremental recompression. If that's possible, that would mean
>> existing systems can start using it. Which is good.
>
>That depends on what do you mean by "incremental"? A single toasted
>datum can only have one compression type, because we only update them
>all in one anyway. But different datums can be compressed differently.
>

I meant different toast values using different compression algorithm,
sorry for the confusion.

>
>> Another question is whether we'd actually want to include the code in
>> core directly, or use system libraries (and if some packagers might
>> decide to disable that, for whatever reason).
>
>I'd personally say we should have an included version, and a
>--with-system-... flag that uses the system one.
>

OK. I'd say to require a system library, but that's a minor detail.


regards

-- 
Tomas Vondra                  http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services 





view thread (70+ messages)  latest in thread

Message-ID: <20190802194859.qxzxq2achzottkup@development>
Permalink:  ../20190802194859.qxzxq2achzottkup@development/
Also on:    postgresql.org/message-id/20190802194859.qxzxq2achzottkup@development

 · 

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: tomas.vondra@2ndquadrant.com, andres@anarazel.de, x4mmm@yandex-team.ru, k.knizhnik@postgrespro.ru, michael@paquier.xyz, vladimirlesk@yandex-team.ru
  Subject: Re: pglz performance
  In-Reply-To: <20190802194859.qxzxq2achzottkup@development>

* 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