Re: [PATCHES] Enums patch v2 - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: [PATCHES] Enums patch v2
Date
Msg-id 20061219145848.GK27098@alvh.no-ip.org
Whole thread Raw
In response to Re: [PATCHES] Enums patch v2  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: [PATCHES] Enums patch v2
Re: [PATCHES] Enums patch v2
Re: [PATCHES] Enums patch v2
List pgsql-hackers
Andrew Dunstan wrote:

> As for efficiency, I agree with what Tom says about alignment and
> padding dissolving away any perceived advantage in most cases. If we
> ever get around to optimising record layout we could revisit it.

I don't, because there are always those that are knowledgeable enough to
know how to reduce space lost to padding.  So it would be nice to have
2-byte enums on-disk, and resolve them based on the column's typid.  But
then, I'm not familiar with the patch at all so I'm not sure if it's
possible.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-hackers by date:

Previous
From: Hans-Juergen Schoenig
Date:
Subject: Re: Core dump in PL/pgSQL ...
Next
From: Magnus Hagander
Date:
Subject: Re: pg_restore fails with a custom backup file