Re: Tuple storage overhead

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Bex <Peter(dot)Bex(at)xs4all(dot)nl>
Cc: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Tuple storage overhead
Date: 2010-04-16 14:34:12
Message-ID: 8790.1271428452@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Richard Huxton <dev(at)archonet(dot)com> writes:
> On 16/04/10 10:41, Peter Bex wrote:
>> Is there a way to reduce the per-tuple storage overhead?

> Short answer - no.

About the only thing you could really do is rethink the table layout.
If you can put more data per row, then the fractional overhead for
tuple headers naturally will be less. Whether this results in a
convenient-to-use table is hard to guess without knowing your
application ...

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-04-16 14:36:10 Re: readline library not found
Previous Message Greg Smith 2010-04-16 14:27:15 Re: Int64GetDatum