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 по дате отправления: