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

From: Hannu Krosing <hannuk(at)google(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Cc: 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>, shihao zhong <zhong950419(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de>
Subject: Re: Direct TOAST v2, faster, smaller and no migration needed
Date: 2026-09-22 15:44:39
Message-ID: CAMT0RQS69qa8bcmOoWTwrXhmud=ZXue_B+P4WP31kHkdZSL6Jg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Now the CI passes in my repo
(https://github.com/postsql/postgres/actions/runs/35711192304)

On Mon, Sep 21, 2026 at 10:21 PM Hannu Krosing <hannuk(at)google(dot)com> wrote:
>
> On Mon, Sep 21, 2026 at 10:12 PM shihao zhong <zhong950419(at)gmail(dot)com> wrote:
> >
> > Hi Hannu,
> >
> > On Mon, Sep 21, 2026 at 10:01 PM Hannu Krosing <hannuk(at)google(dot)com> wrote:
> >
> > > Is there a way to make sure that it actually runs the same way?
> > Yes. cfbot runs the GitHub Actions workflow that is in the tree, so
> > your own fork runs the same jobs.
>
> Thanks a lot!
>
> That was the missing piece :)
>
> > Push the branch to your fork, enable
> > pg-ci.yml under Actions, and add a repository variable PG_CI_ENABLED
> > with the value 1. It is all in src/tools/ci/README.
>
> Regards
> Hannu

Attachment Content-Type Size
v9-0005-Add-amcheck-verification-for-Direct-TOAST-tuples.patch application/x-patch 10.1 KB
v9-0003-Implement-Direct-TOAST-core-storage-reading-and-w.patch application/x-patch 75.6 KB
v9-0001-Refactor-detoasting-and-decompression-pipeline-to.patch application/x-patch 17.0 KB
v9-0002-Add-Direct-TOAST-catalog-GUC-and-reloptions-infra.patch application/x-patch 11.1 KB
v9-0004-Support-Direct-TOAST-in-logical-decoding-replicat.patch application/x-patch 28.7 KB
v9-0006-Add-documentation-for-Direct-TOAST.patch application/x-patch 8.1 KB
v9-0007-Add-pg_ensure_direct_toast-for-in-place-legacy-TO.patch application/x-patch 21.0 KB
v9-0009-Prune-dead-unindexed-TOAST-tuples-directly-to-LP_.patch application/x-patch 5.5 KB
v9-0008-Add-backend-TOAST-architecture-documentation-and-.patch application/x-patch 12.9 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Nathan Bossart 2026-09-22 15:46:56 Re: [Proposal] Expose internal MultiXact member count function for efficient monitoring
Previous Message Sagar Shedge 2026-09-22 15:40:10 Re: postgres_fdw: push down FETCH FIRST .. WITH TIES when server version allows