Get size of variable-length attribute as stored on disk

Поиск
Список
Период
Сортировка
От Christophe Pettus
Тема Get size of variable-length attribute as stored on disk
Дата
Msg-id 33B2BCC6-0CB2-4D0E-AFA0-2C6F1D69B8A2@thebuild.com
обсуждение исходный текст
Ответы Re: Get size of variable-length attribute as stored on disk  (Christophe Pettus <xof@thebuild.com>)
Список pgsql-general
Дерево обсуждения 
Hi,

Is there a way from SQL to get the size of a particular attribute (field in a row) with a variable-length typed as
storedon disk (including compression)?  The use case is to determine the size distribution for setting
TOAST_TUPLE_TARGETand making other decisions about what to store in that field. 

Thanks!

В списке pgsql-general по дате отправления:

Предыдущее
От: Michel Pelletier
Дата:
Сообщение: Re: pg_dumpall renders ALTER TABLE for a view?
Следующее
От: Christophe Pettus
Дата:
Сообщение: Re: Get size of variable-length attribute as stored on disk