Re: [GENERAL] column limit

2007-01-26 Thread Isaac Ben
On 1/26/07, Bruno Wolff III [EMAIL PROTECTED] wrote: On Thu, Jan 25, 2007 at 10:47:50 -0700, Isaac Ben [EMAIL PROTECTED] wrote: 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

[GENERAL] column limit

2007-01-26 Thread Isaac Ben
20,000 columns? Thanks, IB Isaac Ben Jeppsen ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

[GENERAL] column limit

2007-01-25 Thread Isaac Ben
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

Re: [GENERAL] column limit

2007-01-25 Thread Isaac Ben
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 [EMAIL PROTECTED] 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