finding out actual tuple size

Поиск
Список
Период
Сортировка
От Linh Luong
Тема finding out actual tuple size
Дата
Msg-id 200402171539.25278.linh.luong@shaw.ca
обсуждение исходный текст
Ответы Re: finding out actual tuple size  (Andrew Sullivan <ajs@crankycanuck.ca>)
Re: finding out actual tuple size  ("scott.marlowe" <scott.marlowe@ihs.com>)
Список pgsql-general
Hi All,

1. I have been reading and the max size of a tuple is 8K.
I have also read that I can it to a larger size in some config file.  Where is
this file? is it called pg_config.h and is the variable called BLKSZ??

2. Is there a way I can find the actual size of the tuple? Do you go into each
column and find the length of each value and sum it up? I am out of ideas..

if someone knows how please shine some light on my situation..

thanks

--------------------------------
Linh Luong


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

Предыдущее
От: Bill Moran
Дата:
Сообщение: Problems with plpgsql and FOR loops
Следующее
От: pativo@arcor.de (pativo)
Дата:
Сообщение: Re: String manipulation