Re: [HACKERS] Tuple length limit - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] Tuple length limit
Date
Msg-id 199907040427.AAA20813@candle.pha.pa.us
Whole thread Raw
In response to RE: [HACKERS] Tuple length limit  ("Stupor Genius" <stuporg@erols.com>)
List pgsql-hackers
[Charset iso-8859-1 unsupported, filtering to ASCII...]
> > Can someone tell me what the maximum tuple length is?  Is it sort of
> > BLCKSZ or BLCKSZ/2?  I don't remember if we require the ability to have
> > at least two tuples in a block.
> 
> IIRC, the max tuple size was always intended to be BLCKSZ, it's just the max
> size of the text fields that were 4096.  I don't remember any discussions
> ever on this list about trying to control the # of tuples stored per block.
> 

That is what I found too, but vacuum seems to use BLCKSZ/2, varchar uses
BLCKSZ/2, and tuple size is BLCKSZ.  Doesn't make any sense.

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: "Stupor Genius"
Date:
Subject: RE: [HACKERS] Tuple length limit
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Tuple length limit