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@xxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx so that your > message can get through to the mailing list cleanly -- David Brain - bandwidth.com dbrain@xxxxxxxxxxxxx 919.297.1078
