Re: [HACKERS] Tuple length limit

> 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.

Here is what I found with the new code. Seems it works.

---------------------------------------------------------------------------

test=> create table test (x char(8104));
CREATE
test=> insert into test values ('x');
INSERT 21417 1
test=> insert into test values ('x');
INSERT 21418 1
test=> insert into test values ('x');
INSERT 21419 1
test=> insert into test values ('x');
INSERT 21420 1
test=> vacuum;
VACUUM
test=> delete from test;
DELETE 4
test=> vacuum;
VACUUM

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