Re: sorting table columns
Alvaro Herrera <alvherre@commandprompt.com>
From: Alvaro Herrera <alvherre@commandprompt.com>
To: Simon Riggs <simon@2ndquadrant.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2011-12-21T19:02:00Z
Lists: pgsql-hackers
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 > <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. 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 <alvherre@commandprompt.com> The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support