Re: [Q] sequence and index name limits in 8.4

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [Q] sequence and index name limits in 8.4
Дата
Msg-id 24275.1246155555@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [Q] sequence and index name limits in 8.4  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-general
Scott Marlowe <scott.marlowe@gmail.com> writes:
> On Sat, Jun 27, 2009 at 7:09 PM, V S P<toreason@fastmail.fm> wrote:
>> Searched docs and the web but only saw references to the older version
>> of postgres
>> where changing source code was recommended ( NAMEDATALEN) if more than
>> 31 characters
>> in the names are desired.

> Unless you want to compile your own version, I think the curent limit
> is 64 or 63 characters. There are real and measurable performance hits
> as you go over that number.

Also, it hasn't been 32 by default since 7.2, more than seven years ago.
Whatever references you are reading are so out of date as to be
completely untrustworthy ...

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: [Q] sequence and index name limits in 8.4
Следующее
От: Greg Stark
Дата:
Сообщение: Re: Switching from MySQL: ON DUPLICATE KEY UPDATE, plpgsql function