Re: estimating table size - Mailing list pgsql-general

From Tom Lane
Subject Re: estimating table size
Date
Msg-id 15508.1090890552@sss.pgh.pa.us
Whole thread Raw
In response to Re: estimating table size  (Ian Barwick <barwick@gmail.com>)
Responses Re: estimating table size  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
Ian Barwick <barwick@gmail.com> writes:
> There is a little info in the FAQ:
> http://www.postgresql.org/docs/faqs/FAQ.html
> particularly sections 4.6 and 4.14

I think the calculation in section 4.6 is out of date --- it's been
awhile since row headers were 36 bytes.  The more correct number is
between 24 and 32 bytes depending on whether you created the table
WITH OIDS and whether your machine requires 4- or 8-byte alignment.

            regards, tom lane

pgsql-general by date:

Previous
From: tgl@sss.pgh.pa.us
Date:
Subject: Re: Mail Authentification
Next
From: Tom Lane
Date:
Subject: Re: parsing binary varchar[]-s