Re: [HACKERS] text datatype and tuple size limits. - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: [HACKERS] text datatype and tuple size limits.
Date
Msg-id Pine.GSO.4.02A.9910281214130.567-100000@Puma.DoCS.UU.SE
Whole thread Raw
In response to text datatype and tuple size limits.  (Brian Hirt <bhirt@mobygames.com>)
List pgsql-hackers
As far as I could follow it, the query size limit is all but gone, and it
will be for sure in 7.0. Regarding the tuple size limit, we are still
looking for volunteers to tackle that. You should find relevant messages
on this list a few days back.
-Peter

On Wed, 27 Oct 1999, Brian Hirt wrote:

> I'm running into what appears to be some hard coded limits of postgres.
> I've got a table with with a text column that I need to insert large 
> amounts of text into.  I quickly found these two things out:  
> 
> First, the MAX_QUERY_SIZE which is BLCKSZ*2 (or 16384 bytes), prevents
> me from from running the query since my query is much larger than 16384 i
> bytes.  After discovering this, I decided to create a test query just
> smaller than 16384 to see what would happen.  
> 
> The second query returns "Tuple is too big: size 12508".  I didn't bother
> to look into this one because I'd probably spend a lot of time looking,
> instead I am bringing the issue here.


-- 
Peter Eisentraut                  Sernanders vaeg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden



pgsql-hackers by date:

Previous
From: ednut
Date:
Subject: Re: Linux/Postgres 6.5 problems using jdbc w/jdk1.2
Next
From: Peter Eisentraut
Date:
Subject: Re: [HACKERS] psql Week 4.142857