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

From Bruce Momjian
Subject Re: [HACKERS] Tuple length limit
Date
Msg-id 199907040504.BAA23942@candle.pha.pa.us
Whole thread Raw
In response to Tuple length limit  (Bruce Momjian <maillist@candle.pha.pa.us>)
Responses Re: [HACKERS] Tuple length limit
List pgsql-hackers
> 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));CREATEtest=>insert into test values ('x');INSERT 21417 1test=> insert into test values ('x');INSERT 21418
1test=>insert into test values ('x');INSERT 21419 1test=> insert into test values ('x');INSERT 21420 1test=>
vacuum;VACUUMtest=>delete from test;DELETE 4test=> vacuum;VACUUM
 


--  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: Bruce Momjian
Date:
Subject: Re: [HACKERS] Tuple length limit
Next
From: Herouth Maoz
Date:
Subject: Re: [INTERFACES] Time and microseconds?