Обсуждение: What is the length of tuple with a TOAST pointer?

Поиск
Список
Период
Сортировка

What is the length of tuple with a TOAST pointer?

От
Vignesh Raghunathan
Дата:
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?

От
Tom Lane
Дата:
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