size of a table on postgresql - Mailing list pgsql-general

From aravind chandu
Subject size of a table on postgresql
Date
Msg-id 850830.34014.qm@web31403.mail.mud.yahoo.com
Whole thread Raw
Responses Re: size of a table on postgresql  (Tino Wildenhain <tino@wildenhain.de>)
List pgsql-general
Hello,

              The following is the procedure to calculate the disk space occupied by postgresql from a flat file.

In this I didn't understood some terms 
   24 bytes: each row header (approximate)
24 bytes: one int field and one text field
+ 4 bytes: pointer on page to tuple

here row header is taken as 24 bytes and in some sites it is given
row header as 40 bytes and in some 32 bytes
http://www.sbras.ru/rus/docs/db/postgres/doc/howto/faq-english.shtml#3.6
http://www.softlab.ntua.gr/facilities/documentation/unix/postgres/faq-english.html

Is the row header value is constant or it is variable?If so what could be the maximun value?
what is that additional +4bytes as pointer on page to tuple.

Should all these were fixed or is there any command to find the values for these fields?

Please post your comments on it.

Thank You,
Avin.

pgsql-general by date:

Previous
From: Bill Moran
Date:
Subject: Re: automatic REINDEX-ing
Next
From: Magnus Hagander
Date:
Subject: Re: ftell error during pg_dump