Skip site navigation (1) Skip section navigation (2)

Re: estimating table size

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ian Barwick <barwick(at)gmail(dot)com>
Cc: David Parker <dparker(at)tazznetworks(dot)com>,pgsql-general(at)postgresql(dot)org, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Subject: Re: estimating table size
Date: 2004-07-27 01:09:12
Message-ID: 15508.1090890552@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-general
Ian Barwick <barwick(at)gmail(dot)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

In response to

Responses

pgsql-general by date

Next:From: Tom LaneDate: 2004-07-27 01:17:03
Subject: Re: parsing binary varchar[]-s
Previous:From: Tom LaneDate: 2004-07-27 01:00:26
Subject: Re: vacuumdb hanging database cluster

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group