Postgres Pro
Downloads
Home   >   mailing lists

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

From David Andersen
Subject Re: Using ENUM with huge NAMEDATALEN
Date
Msg-id c6bf5b380807261448h65aac228i112cdca380bf4b4@mail.gmail.com
Whole thread Raw
In response to Re: Using ENUM with huge NAMEDATALEN  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Using ENUM with huge NAMEDATALEN  ("David Andersen" <david@andersen.gs>)
List pgsql-performance
Tree view
Hi Tom,

Thanks a lot for the tip! I will try this. You probably saved be a few days of work!

Regards,

David

On Sat, Jul 26, 2008 at 11:44 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
"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: Tom Lane
Date:
Subject: Re: Using ENUM with huge NAMEDATALEN
Next
From: "David Andersen"
Date:
Subject: Re: Using ENUM with huge NAMEDATALEN