Re: [GENERAL] pg_attribute.attnum - wrong column ordinal?

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: [GENERAL] pg_attribute.attnum - wrong column ordinal?
Дата
Msg-id 1260024394.20505.0.camel@vanquo.pezone.net
обсуждение исходный текст
Ответ на Re: [GENERAL] pg_attribute.attnum - wrong column ordinal?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On tor, 2009-12-03 at 10:09 -0500, Tom Lane wrote:
> Alvaro Herrera <alvherre@commandprompt.com> writes:
> > Should we recast the attributes and columns views in information_schema?
> > I notice they still use attnum.
>
> I'd vote against it, at least until we have something better than a
> row_number solution.  That would create another huge performance penalty
> on views that are already ungodly slow.

Should be easy to test the performance impact of this, since the limit
for columns per table is 1600.


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

Предыдущее
От: Tim Bunce
Дата:
Сообщение: Re: First feature patch for plperl - draft [PATCH]
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: PostgreSQL Release Support Policy