Re: Large Rows

On Wed, Oct 26, 2011 at 3:17 AM, Lee Hachadoorian
<lee.hachadoorian@gmail.com> 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