Re: [HACKERS] database size estimates

2007-04-25 Thread Gregory Stark
"Heikki Linnakangas" <[EMAIL PROTECTED]> writes: > Francois Deliege wrote: >> 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 = 31

Re: [HACKERS] database size estimates

2007-04-25 Thread Heikki Linnakangas
Francois Deliege wrote: 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 What data types are those exactly? If those 24-bit fields are

[HACKERS] database size estimates

2007-04-25 Thread Francois Deliege
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