Postgres Pro
Downloads
Home   >   mailing lists

finding out actual tuple size - Mailing list pgsql-general

From Linh Luong
Subject finding out actual tuple size
Date
Msg-id 200402171539.25278.linh.luong@shaw.ca
Whole thread Raw
Responses Re: finding out actual tuple size  (Andrew Sullivan <ajs@crankycanuck.ca>)
Re: finding out actual tuple size  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Bill Moran
Date:
Subject: Problems with plpgsql and FOR loops
Next
From: pativo@arcor.de (pativo)
Date:
Subject: Re: String manipulation