Re: Direct TOAST v2, faster, smaller and no migration needed

From: Nikita Malakhov <hukutoc(at)gmail(dot)com>
To: Hannu Krosing <hannuk(at)google(dot)com>
Cc: Michael Paquier <michael(at)paquier(dot)xyz>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Dilip Kumar <dilipkumarb(at)google(dot)com>, Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>, Yugo Nagata <nagata(at)sraoss(dot)co(dot)jp>
Subject: Re: Direct TOAST v2, faster, smaller and no migration needed
Date: 2026-09-07 07:45:01
Message-ID: CAN-LCVM-rh9j_YbG93S7RUBbeu6-1TEWe4FJQrPqUvmR2cM2JQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Hannu!

Great you're continuing this work! I've started to review your patch set,
and have question about tests and performance: have you tested it against
large toasted values? When experimenting with direct toast before my
prototype
was much faster on small values but starting with relatively large (have to
recover
previous test results so cannot say exact size), about tens of Mbs,
performance
starts to degrade and on very large values it is much slower compared to
the original
mechanics.

--
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 Zhijie Hou (Fujitsu) 2026-09-07 07:52:59 RE: Follow-up review items for update_deleted
Previous Message Richard Guo 2026-09-07 07:43:32 Re: Assert failure in try_nestloop_path()