Postgres Pro
Downloads
Home   >   mailing lists

Re: Using ENUM with huge NAMEDATALEN - Mailing list pgsql-performance

From Tom Lane
Subject Re: Using ENUM with huge NAMEDATALEN
Date
Msg-id 4191.1217108664@sss.pgh.pa.us
Whole thread Raw
In response to Using ENUM with huge NAMEDATALEN  ("David Andersen" <david@andersen.gs>)
Responses Re: Using ENUM with huge NAMEDATALEN  ("David Andersen" <david@andersen.gs>)
List pgsql-performance
Tree view 
"David Andersen" <david@andersen.gs> writes:
> One of the side tables is text with length of up to 900 characters. My
> question is whether I could build PostgreSQL with NAMEDATALEN  (which
> controls the max size of Enums) equal to 900?

I wouldn't recommend it.  Consider changing pg_enum.enumlabel to type
TEXT instead.

            regards, tom lane

pgsql-performance by date:

Previous
From: "David Andersen"
Date:
Subject: Using ENUM with huge NAMEDATALEN
Next
From: "David Andersen"
Date:
Subject: Re: Using ENUM with huge NAMEDATALEN