Re: Performance impact of record sizes

Поиск
Список
Период
Сортировка
Искать
От
Bruce Momjian
Тема
Re: Performance impact of record sizes
Дата
Msg-id
200207160449.g6G4n0l06741@candle.pha.pa.us
Ответ на
Список
Дерево обсуждения
Performance impact of record sizes John Moore <postgres@tinyvital.com>
Re: Performance impact of record sizes Bruce Momjian <pgman@candle.pha.pa.us>
Re: Performance impact of record sizes John Moore <postgres@tinyvital.com>
Re: Performance impact of record sizes Bruce Momjian <pgman@candle.pha.pa.us>
Re: Performance impact of record sizes Tom Lane <tgl@sss.pgh.pa.us>
Re: Performance impact of record sizes Bruce Momjian <pgman@candle.pha.pa.us>
Re: Performance impact of record sizes Tom Lane <tgl@sss.pgh.pa.us>
Re: Performance impact of record sizes Bruce Momjian <pgman@candle.pha.pa.us>
Re: Performance impact of record sizes Bruce Momjian <pgman@candle.pha.pa.us>
Re: Performance impact of record sizes Bruce Momjian <pgman@candle.pha.pa.us>
Re: Performance impact of record sizes John Moore <wx-chase@tinyvital.com>
Re: Performance impact of record sizes Shaun Thomas <sthomas@townnews.com>
Bruce Momjian wrote:
> 
> I see in the data types section for character types this text:
> 
>      There are no performance differences between these three types,
>      apart from the increased storage size when using the blank-padded
>      type.
> 
> I can't improve on that.

I added a mention of TOAST in the character data type docs:

	Long values are also stored in background tables so they don't
	interfere with rapid access to the shorter column values.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
В списке pgsql-admin по дате отправления
От: Bruce Momjian
Дата:
От: Tom Lane
Дата:
Сообщение: Re: initdb failing - core dump
FAQ