Hmm,
k, then I don't know exactly what happens. I have some values in my composite type. The size of the index tuple (if
comingfrom one table and being copied to the target table) is about 15x bytes. Otherwise, if I insert the same tuple
directly,it is about 12kb. So, I don't know exactly what happens here, unfortunately.
Best regardsCarsten Kropf
Am 24.06.2010 um 17:08 schrieb Tom Lane:
> Carsten Kropf <ckropf2@fh-hof.de> writes:
>> However, it is a little bit strange, that I get toasted values (when inserting from another table) and untoasted
values,if I insert items directly. Could anybody please explain this to me?
>
> Huh? An index will never ever get passed an externally-toasted value.
> See the TOAST_INDEX_HACK code in indextuple.c.
>
> regards, tom lane
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers