From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Speeding up tupledesc copying |
Date: | 2005-03-06 19:14:47 |
Message-ID: | 6045.1110136487@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I was just doing some profiling of plpgsql record operations, and
noticed that an unreasonable amount of runtime was being consumed
by palloc/pfree calls coming from CreateTupleDescCopy. The reason
for this of course is that each attribute's storage is separately
palloc'd. This seems a little silly given that the tupdesc
management code doesn't have any provision for changing the number
of attributes in an existing tupdesc. We could just as well
allocate all the space needed in one palloc call, with a little bit
of added address-arithmetic to set up the pointers. This would
require some localized changes in tupdesc.c and relcache.c,
but most users of tupdescs would never know the difference.
Can anyone see a reason not to make this change?
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2005-03-06 19:24:38 | Implementation of SQLCODE and SQLERRM variables for PL/pgSQL |
Previous Message | Magnus Hagander | 2005-03-06 18:44:03 | Re: refactoring fork() and EXEC_BACKEND |