Re: [HACKERS] text datatype and tuple size limits.

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: [HACKERS] text datatype and tuple size limits.
Дата
Msg-id Pine.GSO.4.02A.9910281214130.567-100000@Puma.DoCS.UU.SE
обсуждение исходный текст
Ответ на text datatype and tuple size limits.  (Brian Hirt <bhirt@mobygames.com>)
Список 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 по дате отправления:

Предыдущее
От: ednut
Дата:
Сообщение: Re: Linux/Postgres 6.5 problems using jdbc w/jdk1.2
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: [HACKERS] psql Week 4.142857