Re: Saving bytes in custom data type

From: Daniele Varrazzo <daniele(dot)varrazzo(at)gmail(dot)com>
To: Merlin Moncure <mmoncure(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Saving bytes in custom data type
Date: 2011-03-16 22:26:04
Message-ID: AANLkTikp2BYev8fZ34bPNZJWE61nTDtoc67iJfpJ6-9M@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Mar 16, 2011 at 6:29 PM, Merlin Moncure <mmoncure(at)gmail(dot)com> wrote:

> question: if you are storing just flags and bytes, why not use a bytea
> and store the flags out of line?

I'm not sure I understand your question. I am writing a custom
datatype with variable size more or less following the guidelines in
<http://www.postgresql.org/docs/9.0/static/xtypes.html>.

More in details I am hacking at a GMP wrapper
<http://pgmp.projects.postgresql.org/> and trying to store GMP
bignums, which I can re-create by just storing a variable list of
unsigned longs and a flag for the sign (note that this is not the
structure the GMP library use, but is enough data to re-create it and
one of the possible form of storage as a varlena - I'm just exploring
to decide the best one).

What do you mean for storing the flag out of line?

-- Daniele

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Aleksey Tsalolikhin 2011-03-16 23:12:30 Re: autovacuum issue after upgrade to 9.0.1
Previous Message Tomas Vondra 2011-03-16 22:16:44 Re: query taking much longer since Postgres 8.4 upgrade