Re: size of bytea + performance issues

From: "tschak" <jochen(dot)schlosser(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: size of bytea + performance issues
Date: 2006-01-31 17:15:18
Message-ID: 1138727718.556937.245840@o13g2000cwo.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Allright... do you mean an alignment with an offset of 4/8 bit or byte?
If it is just bit I cannot really follow the calculation...
Nevertheless it sounds like an explanation for this "effect".

I have one more question concerning size. The following table
create table test(val0 unsigned smallint,
... ... ... .. ..., val7 unsigned smallint,
bulk bytea);

needs app. 100 Bytes per row even though the user data only uses
8*2Bytes (vali) + 40Bytes (the sizye of my bytea). Does that mean, that
the system needs 46 bytes for internal represantationsor is the
alignment factor a again a source of this "blowup"?

Thanks for your help,
Tschak

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message nboutelier 2006-01-31 17:34:21 Re: Can't get the field = ANY(array) clause to work...
Previous Message Martijn van Oosterhout 2006-01-31 16:50:46 Re: size of bytea + performance issues