"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
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
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