Re: Fixed length data types issue

From: Gregory Stark <stark(at)enterprisedb(dot)com>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Fixed length data types issue
Date: 2006-09-07 10:57:26
Message-ID: 87bqpsc5bd.fsf@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Gregory Stark <stark(at)enterprisedb(dot)com> writes:

> Martijn van Oosterhout <kleptog(at)svana(dot)org> writes:
>
>> So you end up storing the typmod in the Datum itself, which brings you
>> right back to varlena.
>
> Not really since the Datum doesn't actually end up on disk in the case of
> pass-by-reference.

Just brain storming here. But what happens if we make Datum 2*sizeof(pointer)
and stored the typmod and/or attlen in it?

Obviously it means the memory use goes up dramatically. But the disk i/o could
potentially be reduced dramatically as well.

Does it let us do anything else we've been dreaming of but not thought doable?
Does it cause any fundamental problems?

--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Martijn van Oosterhout 2006-09-07 11:02:33 Re: Fixed length data types issue
Previous Message Nimesh Satam 2006-09-07 10:49:01 Re: [PATCHES] Template0 age is increasing speedily.