Re: [RFC] new digest datatypes, or generic fixed-len hex types? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [RFC] new digest datatypes, or generic fixed-len hex types?
Date
Msg-id 11267.1248709009@sss.pgh.pa.us
Whole thread Raw
In response to Re: [RFC] new digest datatypes, or generic fixed-len hex types?  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-hackers
Merlin Moncure <mmoncure@gmail.com> writes:
> On Mon, Jul 27, 2009 at 10:20 AM, Tom Lane<tgl@sss.pgh.pa.us> wrote:
>> Wasn't this proposed and rejected before? �(Or more to the point,
>> why'd you bother? �The advantage over bytea seems negligible.)

> well, one nice things about the fixed length types is that you can
> keep your table from needing a toast table when you have a bytea in
> it.

If you don't actually use the toast table, it doesn't cost anything very
noticeable ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Non-blocking communication between a frontend and a backend (pqcomm)
Next
From: Robert Haas
Date:
Subject: Re: When is a record NULL?