On Fri, Jun 18, 2010 at 1:59 PM, Andrew Dunstan <and...@dunslane.net> wrote: > This was debated when we implemented enums. As between 1,2 and 4 there is > often not much to choose, as alignment padding makes it pretty much the > same. But any of them are more efficient than storing a numeric value or the > label itself.
I was assuming the alternative was an integer, rather than a numeric... but yeah, a numeric or the label itself would definitely be larger. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers