Skip site navigation (1) Skip section navigation (2)

pgsql-server: Resurrect heap_deformtuple(), this time implemented as a

From: tgl(at)svr1(dot)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql-server: Resurrect heap_deformtuple(), this time implemented as a
Date: 2004-06-04 20:35:21
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-committers
Log Message:
Resurrect heap_deformtuple(), this time implemented as a singly nested
loop over the fields instead of a loop around heap_getattr.  This is
considerably faster (O(N) instead of O(N^2)) when there are nulls or
varlena fields, since those prevent use of attcacheoff.  Replace loops
over heap_getattr with heap_deformtuple in situations where all or most
of the fields have to be fetched, such as printtup and tuptoaster.
Profiling done more than a year ago shows that this should be a nice
win for situations involving many-column tables.

Modified Files:
        heaptuple.c (r1.90 -> r1.91)
        printtup.c (r1.81 -> r1.82)
        tuptoaster.c (r1.41 -> r1.42)
        tablecmds.c (r1.109 -> r1.110)
        typecmds.c (r1.57 -> r1.58)
        execJunk.c (r1.40 -> r1.41)
        spi.c (r1.115 -> r1.116)
        heapam.h (r1.89 -> r1.90)

pgsql-committers by date

Next:From: Tom LaneDate: 2004-06-05 01:55:06
Subject: pgsql-server: Make the world very nearly safe for composite-type columns
Previous:From: Bruce MomjianDate: 2004-06-04 13:30:08
Subject: pgsql-server: The attached patch will create a dummy pg_config_paths.h.

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group