Re: [PATCH] Compression dictionaries for JSONB

From: Nikita Malakhov <hukutoc(at)gmail(dot)com>
To: Aleksander Alekseev <aleksander(at)timescale(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, Jacob Champion <jchampion(at)timescale(dot)com>, Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
Subject: Re: [PATCH] Compression dictionaries for JSONB
Date: 2023-05-17 11:32:13
Message-ID: CAN-LCVOEj1qPwT0diqC3b7z8ZR9hqP49sC7SEh7d9D61-vGGHA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi hackers!

As discussed above, I've created a new thread on the Extension of the TOAST
pointer subject -
https://www.postgresql.org/message-id/flat/CAN-LCVMq2X%3Dfhx7KLxfeDyb3P%2BBXuCkHC0g%3D9GF%2BJD4izfVa0Q%40mail.gmail.com
Please check and comment.

On Thu, Apr 27, 2023 at 1:43 PM Nikita Malakhov <hukutoc(at)gmail(dot)com> wrote:

> Hi,
>
> I think I should open a new thread related to TOAST pointer refactoring
> based on Pluggable TOAST, COPY and looping in retrieving new TOAST
> value OID issues.
>
> On Wed, Apr 26, 2023 at 4:00 PM Aleksander Alekseev <
> aleksander(at)timescale(dot)com> wrote:
>
>> Hi Nikita,
>>
>> > The External TOAST pointer is very limited to the amount of service data
>> > it could keep, that's why we introduced the Custom TOAST pointers in the
>> > Pluggable TOAST. But keep in mind that changing the TOAST pointer
>> > structure requires a lot of quite heavy modifications in the core -
>> along with
>> > some obvious places like insert/update/delete datum there is very
>> serious
>> > issue with logical replication.
>> > The Pluggable TOAST was rejected, but we have a lot of improvements
>> > based on changing the TOAST pointer structure.
>>
>> Now I see what you meant [1]. I agree that we should focus on
>> refactoring TOAST pointers first. So I suggest we continue discussing
>> this in a corresponding thread and return to this one later.
>>
>> [1]:
>> https://www.postgresql.org/message-id/CAJ7c6TPSvR2rKpoVX5TSXo_kMxXF%2B-SxLtrpPaMf907tX%3DnVCw%40mail.gmail.com
>>
>> --
>> Best regards,
>> Aleksander Alekseev
>>
>
>
> --
> Regards,
>
> --
> Nikita Malakhov
> Postgres Professional
> The Russian Postgres Company
> https://postgrespro.ru/
>

--
Regards,
Nikita Malakhov
Postgres Professional
The Russian Postgres Company
https://postgrespro.ru/

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Daniel Gustafsson 2023-05-17 11:49:54 Re: pipe_read_line for reading arbitrary strings
Previous Message vignesh C 2023-05-17 11:15:24 Re: Support logical replication of DDLs