Postgres Pro
Downloads
Home   >   mailing lists

Thread: What is the length of tuple with a TOAST pointer?

What is the length of tuple with a TOAST pointer?

From
Vignesh Raghunathan
Date:
Hello,

If a tuple has a pointer to a TOAST table entry, would the tuple's length stored in its corresponding Item include the length of the entry in the TOAST table?

Thanks,
Vignesh 

Re: What is the length of tuple with a TOAST pointer?

From
Tom Lane
Date:
Vignesh Raghunathan <vignesh.pgsql@gmail.com> writes:
> If a tuple has a pointer to a TOAST table entry, would the tuple's length
> stored in its corresponding Item include the length of the entry in the
> TOAST table?

No.  It would include the length of the TOAST-pointer datum.
        regards, tom lane