RE: [INTERFACES] 8k limit - Mailing list pgsql-interfaces

From Ansley, Michael
Subject RE: [INTERFACES] 8k limit
Date
Msg-id 1BF7C7482189D211B03F00805F8527F748C1BC@S-NATH-EXCH2
Whole thread Raw
Responses Re: [INTERFACES] 8k limit
List pgsql-interfaces
The 8kB limit you are refering to is probably the tuple-length limit.  This
can be altered to a maximum of 64kB (I think, might only be 32kB), but you
need to recompile your server, and initdb.  This limit will not be removed
until at least version 7.
There is also a limit on the length of a query string, if you are using a
6.5.x production release.  This limit is set to twice the tuple-length
limit, so if your block-size (tuple-length) is set to 8kB, then your maximum
query string length will be 16kB.  If you recompile your server to up the
block-size to, say, 32kB, then your query string limit will automatically be
altered to 64kB.

As far as the number of los go, I'm afraid I can't help you on that one.

MikeA


>> -----Original Message-----
>> From: StOo [mailto:stuart@comodo.net]
>> Sent: Tuesday, October 26, 1999 2:45 PM
>> To: pgsql-interfaces@postgreSQL.org
>> Subject: [INTERFACES] 8k limit
>> 
>> 
>> 
>> Hello,
>>  Im trying to store a string of ascii characters greater 
>> than 8k. Is there a
>> tunable which will allow me to alter the 8k max limit? Im 
>> pretty sure this has
>> been discussed here before =). Next question is whats the 
>> max number of large
>> objects you can store? I think its about 4 billion , am i wrong?
>> 
>> 
>> 
>> +-=-=-=-=-=-=-=StOo=-=-=-=-=-=-=-+
>> 
>> Stuart Hodgkinson Software Engineer
>> stuart@comodo.net 
>> 
>> 
>> 
>> ************
>> 


pgsql-interfaces by date:

Previous
From: StOo
Date:
Subject: 8k limit
Next
From: Tom Lane
Date:
Subject: Re: [INTERFACES] 8k limit