From: | Francois Deliege <fdeliege(at)cs(dot)aau(dot)dk> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | database size estimates |
Date: | 2007-04-25 13:51:54 |
Message-ID: | 462F5CFA.6050801@cs.aau.dk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
I am trying to estimate the size of a table composed of 51754000 rows.
Each row has 31 attributes: 16 x bit(24) and 15 x bit(8)
So, the payload should be:
51754000 x ( 16 x 24 + 15 x 24 ) bits = 3115 MB
Now, from what I understand from postgresql manual is that the overhead
is composed of
32 bytes per row + 20 bytes per page.
This leads me to approx. 1700 MB overhead.
Therefore a total table size of 4900 MB.
However, when I load the table, the table reaches the size of 21500 MB,
i.e., 400% of my estimate.
The table has no toast table, no index.
So I am wondering if someone could give me a better estimate.
Cheers,
Francois
Attachment | Content-Type | Size |
---|---|---|
fdeliege.vcf | text/x-vcard | 326 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Meskes | 2007-04-25 14:06:33 | Re: ECPG failure on BF member Vaquita (Windows Vista) |
Previous Message | Gregory Stark | 2007-04-25 13:32:20 | Re: Avoiding unnecessary reads in recovery |