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

From Jan Wieck
Subject Re: row is too big: size 8916, maximum size 8136
Date
Msg-id 439794A9.5040304@Yahoo.com
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
On 12/6/2005 9:03 PM, 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.

The external reference of a toasted attribute is 20 bytes in size.

I might be wrong, but at 700 columns you have to ask your developers 
some serious questions about their qualification.


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Reducing contention for the LockMgrLock
Next
From: Christopher Kings-Lynne
Date:
Subject: HOOKS for Synchronous Replication?