Re: column limit

Hi,
Sorry, I forgot to post back to the list instead of just replying
individual responders.

The data is gene expression data with 20,000 dimensions. Part of the
project I'm working on is to discover what dimensions are truly
independent. But to start with I need to have
all of the data available in a master table to do analysis on. After
the analysis I hope to derive subsets of much lower dimensionality.

IB

Isaac Ben Jeppsen

On 1/25/07, David Brain <dbrain(at)bandwidth(dot)com> wrote:
> Hi,
>
> Seeing as how no one has asked this question yet - I have to ask, why do
> you need 20,000 columns? I'm sure I'm not the only one who is curious.
>
> It's hard to think of a situation where this couldn't be solved by using
> a schema with parent/child tables to have 20000 rows per record rather
> than 20000 columns.
>
> David.
>
> Isaac Ben wrote:
> > Hi,
> > I'm trying to create a table with 20,000 columns of type int2, but I
> > keep getting the error message that the limit is 1600. According to
> > this message
> > http://archives.postgresql.org/pgsql-admin/2001-01/msg00199.php
> > it can be increased, but only up to about 6400. Can anyone tell me
> > how to get 20,000 columns?
> >
> > Thanks,
> > IB
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: if posting/reading through Usenet, please send an appropriate
> > subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> > message can get through to the mailing list cleanly
>
>
> --
> David Brain - bandwidth.com
> dbrain(at)bandwidth(dot)com
> 919.297.1078
>