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

From: Tomas Vondra <tomas(at)vondra(dot)me>
To: Hannu Krosing <hannuk(at)google(dot)com>, Andres Freund <andres(at)anarazel(dot)de>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Michael Paquier <michael(at)paquier(dot)xyz>, 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>, Nikita Malakhov <hukutoc(at)gmail(dot)com>
Subject: Re: Direct TOAST v2, faster, smaller and no migration needed
Date: 2026-09-21 20:11:41
Message-ID: f752cff4-d552-42fe-8fd3-d7e526eb2448@vondra.me
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 9/21/26 22:01, Hannu Krosing wrote:
> Is there a way to make sure that it actually runs the same way?
>
> The reason I have been sending it is that the tests do pass locally,
> even the ones that fail in CI and I have been trying to figure out why
>

That's why Andres was suggesting you enable CI on your github repo, in
which case you'll be able to debug the failures there.

It's also possible to investigate the logs from cfbot runs, by clicking
on the link in cfbot:

https://github.com/postgres/postgres-cfbot/actions/runs/35639175676/attempts/1

From a cursory look, I guess there's a couple compiler warnings due to
toast_decompress_datum now being unused, etc. Some of the failures seem
to be caused by lz4 being the default TOAST on some of the machines (and
you seem to expect pglz).

Haven't looked further.

regards

--
Tomas Vondra

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message shihao zhong 2026-09-21 20:12:27 Re: Direct TOAST v2, faster, smaller and no migration needed
Previous Message Hannu Krosing 2026-09-21 20:01:18 Re: Direct TOAST v2, faster, smaller and no migration needed