| From: | Hannu Krosing <hannuk(at)google(dot)com> |
|---|---|
| To: | Nikita Malakhov <hukutoc(at)gmail(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-21 09:55:03 |
| Message-ID: | CAMT0RQRu2csBpDAggMb-AGJ00T6of8wBNrcv_b-hq=NzDWx2yg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
The latest patch set, now includes patch to pruning to treat a TOAST tuple
with NULL chunk_id as if it had HEAP_ONLY_TUPLE set and release it
immediately.
I am running some tests on both this (in classic and direct toast mode)
and the OID8 toast to write up a better comparison
| Attachment | Content-Type | Size |
|---|---|---|
| v4-0002-Add-Direct-TOAST-catalog-GUC-and-reloptions-infra.patch | application/x-patch | 10.3 KB |
| v4-0005-Add-amcheck-verification-for-Direct-TOAST-tuples.patch | application/x-patch | 10.1 KB |
| v4-0003-Implement-Direct-TOAST-core-storage-reading-and-w.patch | application/x-patch | 78.2 KB |
| v4-0006-Add-documentation-for-Direct-TOAST.patch | application/x-patch | 8.1 KB |
| v4-0007-Add-pg_ensure_direct_toast-for-in-place-legacy-TO.patch | application/x-patch | 21.0 KB |
| v4-0008-Add-backend-TOAST-architecture-documentation-and-.patch | application/x-patch | 12.9 KB |
| v4-0009-Prune-dead-unindexed-TOAST-tuples-directly-to-LP_.patch | application/x-patch | 5.5 KB |
| v4-0001-Refactor-detoasting-and-decompression-pipeline-to.patch | application/x-patch | 17.1 KB |
| v4-0004-Support-Direct-TOAST-in-logical-decoding-replicat.patch | application/x-patch | 28.2 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alexandre Felipe | 2026-09-21 09:56:11 | Re: Restructured Shared Buffer Hash Table |
| Previous Message | Alexandre Felipe | 2026-09-21 09:49:42 | Re: [patch] Cache invalidation for I/O Workers |