On Wed, Oct 26, 2011 at 3:17 AM, Lee Hachadoorian <lee.hachadoorian@xxxxxxxxx> 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 > the 8k row size limit once about half the columns are populated. As far as I > can understand, even though a row theoretically supports a 1.6TB (!) row > size, this only works for TOASTable data types (primarily text?). The vast > majority of the 23k columns I'm storing are bigint. Arrays are toastable, so you are getting an error from another source. create table array_example as select array_fill(1010110101010101, ARRAY[100000], ARRAY[1])::bigint[] as arraycol; -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
