Re: Using ENUM with huge NAMEDATALEN

Поиск
Список
Период
Сортировка
От David Andersen
Тема Re: Using ENUM with huge NAMEDATALEN
Дата
Msg-id c6bf5b380807261448h65aac228i112cdca380bf4b4@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Using ENUM with huge NAMEDATALEN  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Using ENUM with huge NAMEDATALEN  ("David Andersen" <david@andersen.gs>)
Список 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@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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Using ENUM with huge NAMEDATALEN
Следующее
От: "David Andersen"
Дата:
Сообщение: Re: Using ENUM with huge NAMEDATALEN