Re: sorting table columns

Поиск
Список
Период
Сортировка
Искать
От
Alvaro Herrera
Тема
Re: sorting table columns
Дата
Msg-id
1324493999-sup-1134@alvh.no-ip.org
Ответ на
Список
Дерево обсуждения
sorting table columns Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: sorting table columns Tom Lane <tgl@sss.pgh.pa.us>
Re: sorting table columns Alvaro Herrera <alvherre@commandprompt.com>
Re: sorting table columns Tom Lane <tgl@sss.pgh.pa.us>
Re: sorting table columns Alvaro Herrera <alvherre@commandprompt.com>
Re: sorting table columns Simon Riggs <simon@2ndQuadrant.com>
Re: sorting table columns Alvaro Herrera <alvherre@commandprompt.com>
Re: sorting table columns Simon Riggs <simon@2ndQuadrant.com>
Re: sorting table columns Alvaro Herrera <alvherre@commandprompt.com>

Excerpts from Simon Riggs's message of mié dic 21 15:53:20 -0300 2011:
> On Wed, Dec 21, 2011 at 1:42 PM, Alvaro Herrera
>  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.

Hm, right.

> Was there something you're working on likely to preventing >240 cols?

No, not at all.

> Just worth documenting what you see at this stage.

I'll keep my eyes open :-)

-- 
Álvaro Herrera 
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

В списке pgsql-hackers по дате отправления
От: Alvaro Herrera
Дата:
Сообщение: Re: bghinter process
От: Simon Riggs
Дата:
Сообщение: Re: CLOG contention
FAQ