Re: Using ENUM with huge NAMEDATALEN

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "David Andersen" <david(at)andersen(dot)gs>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Using ENUM with huge NAMEDATALEN
Date: 2008-07-26 21:44:24
Message-ID: 4191.1217108664@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"David Andersen" <david(at)andersen(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message David Andersen 2008-07-26 21:48:50 Re: Using ENUM with huge NAMEDATALEN
Previous Message David Andersen 2008-07-26 21:22:09 Using ENUM with huge NAMEDATALEN