Re: [HACKERS] Tuple length limit

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [HACKERS] Tuple length limit
Дата
Msg-id 199907040504.BAA23942@candle.pha.pa.us
обсуждение исходный текст
Ответ на Tuple length limit  (Bruce Momjian <maillist@candle.pha.pa.us>)
Ответы Re: [HACKERS] Tuple length limit  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] Tuple length limit
Следующее
От: Herouth Maoz
Дата:
Сообщение: Re: [INTERFACES] Time and microseconds?