Postgres Pro
Downloads
Home   >   mailing lists

Re: build array of composites in SPI - Mailing list pgsql-general

From Tom Lane
Subject Re: build array of composites in SPI
Date
Msg-id 1535.1258481232@sss.pgh.pa.us
Whole thread Raw
In response to build array of composites in SPI  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: build array of composites in SPI  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-general
Tree view 
Merlin Moncure <mmoncure@gmail.com> writes:
> 2) build the composite via:
>   2a) TupleDescGetAttInMetadata
>   2b) BuildTupleFromCStrings
>   2c) get datum/HeapTupleGetDatum

If it's performance critical, you might want to avoid the extra overhead
of the AttInMetadata API.  Especially if you know the column datatypes
ahead of time, and even more especially if you have the values in datum
rather than C-string form.  Consider using heap_form_tuple directly.

            regards, tom lane

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: build array of composites in SPI
Next
From: Alexey Klyukin
Date:
Subject: Re: plperl: spi_query_prepared/spi_fetchrow versus spi_exec_prepared: memory?