Re: Make tuple deformation faster

David Rowley <dgrowleyml@gmail.com>

From: David Rowley <dgrowleyml@gmail.com>

To: Andres Freund <andres@anarazel.de>

Cc: Victor Yegorov <vyegorov@gmail.com>, Matthias van de Meent <boekewurm+postgres@gmail.com>, PostgreSQL Developers <pgsql-hackers@lists.postgresql.org>

Date: 2024-12-20T10:31:35Z

Lists: pgsql-hackers

Attachments

v8-0001-Optimize-alignment-calculations-in-tuple-form-def.patch (application/octet-stream) patch v8-0001
v8-0002-Speedup-tuple-deformation-with-additional-functio.patch (application/octet-stream) patch v8-0002

On Fri, 20 Dec 2024 at 23:04, David Rowley <dgrowleyml@gmail.com> wrote:
> I've now pushed the 0001 patch and the 0002 patch as one commit.  I'm
> going to give the buildfarm a bit of time then push the commit to
> remove pg_attribute.attcacheoff. I'm planning on letting that settle
> overnight then if all is well push the attalignby changes.

The attcacheoff removal is now pushed. I've attached the two remaining patches.

David

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Fix possible Assert failure in verify_compact_attribute()
- 33b06a20016d 18.0 landed
Speedup tuple deformation with additional function inlining
- 58a359e585d0 18.0 landed
Fix race condition in TupleDescCompactAttr assert code
- 6f3820f37aba 18.0 landed
Optimize alignment calculations in tuple form/deform
- db448ce5ad36 18.0 landed
Remove pg_attribute.attcacheoff column
- 02a8d0c45253 18.0 landed
Introduce CompactAttribute array in TupleDesc, take 2
- 5983a4cffc31 18.0 landed
Introduce CompactAttribute array in TupleDesc
- d28dff3f6cd6 18.0 landed
Use TupleDescAttr macro consistently
- 65b71dec2d57 18.0 landed