Re: Storage consumption

On Fri, 14 Nov 2003, Troels Arvin wrote:

> Hello,
>
> For some very data-intensive projects it's interesting how much space the
> DBMS uses for the storage of data, so I'm investigating how space
> efficient different DBMSes are.
>
> In the PostgreSQL manual, it's written that values of the type INTEGER
> take op four bytes. I was curious about how close to real-World this
> number is, so I did a test: How much space does PostgreSQL use when
> storing 100000 rows where each row consists of a single INTEGER value?
>

You are measuring the space used to store one row of one int column.  To
test the space used just by one int column a more accurate test would be
to measure the difference in disk usage between a table with one int
column and a table with two int columns.

Kris Jurka