Re: sorting table columns

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: sorting table columns
Дата
Msg-id CA+U5nMKAWG8fJ8uq23QPbFHrLsYqB4P_FWYmKxHS6xZ0NfxU7g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: sorting table columns  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: sorting table columns  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-hackers
On Wed, Dec 21, 2011 at 1:42 PM, Alvaro Herrera
<alvherre@commandprompt.com> wrote:

> This one I'm not sure about at all:
>
>> * "very large number of columns" for statistical data sets where we
>> automatically vertically partition the heap when faced with large
>> numbers of column definitions

We currently have pg_attribute.attnum as an int2, so we can store up
to 32768 columns without changing that size, as long as we have some
place to put the data.

Was there something you're working on likely to preventing >240 cols?
Just worth documenting what you see at this stage.

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services


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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: bghinter process
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: bghinter process