Re: [GENERAL] Large Rows

2011-10-26 Thread Lee Hachadoorian
On Wed, Oct 26, 2011 at 10:15 AM, Simon Riggs wrote: > On Wed, Oct 26, 2011 at 2:57 PM, Lee Hachadoorian > wrote: > > > Interesting. Although your example of one, 10-dimension array works, > > five hundred 2-dimension arrays does not work. I can do the SELECT, but > the > > CREATE TABLE fail

Re: [GENERAL] Large Rows

2011-10-26 Thread Simon Riggs
On Wed, Oct 26, 2011 at 2:57 PM, Lee Hachadoorian wrote: > Interesting. Although your example of one, 10-dimension array works, > five hundred 2-dimension arrays does not work. I can do the SELECT, but the > CREATE TABLE fails: > > ERROR: row is too big: size 9024, maximum size 8160 > SQL sta

Re: [GENERAL] Large Rows

2011-10-26 Thread Simon Riggs
On Wed, Oct 26, 2011 at 3:17 AM, Lee Hachadoorian wrote: > I decided > to try to combine all the sequences into one table using array columns. > (This would actually make querying easier since the users wouldn't have to > constantly JOIN the sequences in their queries.) Next problem: I run into >

Re: [GENERAL] Large Rows

2011-10-26 Thread Lee Hachadoorian
On 10/26/2011 12:31 AM, David Johnston wrote: On Oct 25, 2011, at 22:17, Lee Hachadoorian wrote: I need some advice on storing/retrieving data in large rows. Invariably someone points out that very long rows are probably poorly normalized, but I have to deal with how to store a dataset whi

Re: [GENERAL] Large Rows

2011-10-25 Thread Royce Ausburn
On 26/10/2011, at 1:17 PM, Lee Hachadoorian wrote: > I need some advice on storing/retrieving data in large rows. Invariably > someone points out that very long rows are probably poorly normalized, but I > have to deal with how to store a dataset which cannot be changed, > specifically the ~23

Re: [GENERAL] Large Rows

2011-10-25 Thread David Johnston
On Oct 25, 2011, at 22:17, Lee Hachadoorian wrote: > I need some advice on storing/retrieving data in large rows. Invariably > someone points out that very long rows are probably poorly normalized, but I > have to deal with how to store a dataset which cannot be changed, > specifically the ~23

[GENERAL] Large Rows

2011-10-25 Thread Lee Hachadoorian
I need some advice on storing/retrieving data in large rows. Invariably someone points out that very long rows are probably poorly normalized, but I have to deal with how to store a dataset which cannot be changed, specifically the ~23,000 column US Census American Community Survey. The Census