Re: Using ENUM with huge NAMEDATALEN

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

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(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> "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-27 00:13:47 Re: Using ENUM with huge NAMEDATALEN
Previous Message Tom Lane 2008-07-26 21:44:24 Re: Using ENUM with huge NAMEDATALEN