enum for performance? - Mailing list pgsql-performance

From Whit Armstrong
Subject enum for performance?
Date
Msg-id 8ec76080906171506ia7ba3ceo1320d4c6430cac67@mail.gmail.com
Whole thread Raw
Responses Re: enum for performance?
Re: enum for performance?
List pgsql-performance
I have a column which only has six states or values.

Is there a size advantage to using an enum for this data type?
Currently I have it defined as a character(1).

This table has about 600 million rows, so it could wind up making a
difference in total size.

Thanks,
Whit

pgsql-performance by date:

Previous
From: Bryce Ewing
Date:
Subject: Re: Index Scan taking long time
Next
From: Tom Lane
Date:
Subject: Re: enum for performance?