Re: [HACKERS] Tuple length limit

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [HACKERS] Tuple length limit
Дата
Msg-id 199907040427.AAA20813@candle.pha.pa.us
обсуждение исходный текст
Ответ на RE: [HACKERS] Tuple length limit  ("Stupor Genius" <stuporg@erols.com>)
Список 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 по дате отправления:

Предыдущее
От: "Stupor Genius"
Дата:
Сообщение: RE: [HACKERS] Tuple length limit
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] Tuple length limit