Re: [GENERAL] pg_attribute.attnum - wrong column ordinal? - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: [GENERAL] pg_attribute.attnum - wrong column ordinal?
Date
Msg-id 1260024394.20505.0.camel@vanquo.pezone.net
Whole thread Raw
In response to Re: [GENERAL] pg_attribute.attnum - wrong column ordinal?  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Tim Bunce
Date:
Subject: Re: First feature patch for plperl - draft [PATCH]
Next
From: Simon Riggs
Date:
Subject: Re: PostgreSQL Release Support Policy