Re: row is too big: size 8916, maximum size 8136 - Mailing list pgsql-hackers

From Mark Kirkwood
Subject Re: row is too big: size 8916, maximum size 8136
Date
Msg-id 43967576.9050507@paradise.net.nz
Whole thread Raw
In response to row is too big: size 8916, maximum size 8136  (Euler Taveira de Oliveira <eulerto@yahoo.com.br>)
List pgsql-hackers
Euler Taveira de Oliveira wrote:
> Hi,
> 
> I'm doing some tests with a 700 columns' table. But when I try to load
> some data with INSERT or COPY I got that message. I verified that the
> BLCKZ is limiting the tuple size but I couldn't have a clue why it's
> not using TOAST. I'm using PostgreSQL 8.0.3 in Slackware 10.1 box.
> Let me know if you want a test case or other useful information.
> 
> 

700 columns - yuck... recompiling with BLCKSZ=16384 or 32768 (say) might 
allow you this many ....(will require an initdb).

regards

Mark


pgsql-hackers by date:

Previous
From: Gregory Maxwell
Date:
Subject: Re: Replication on the backend
Next
From: Markus Schiltknecht
Date:
Subject: Re: Replication on the backend