Re: Performance impact of record sizes
От
Bruce Momjian
Тема
Re: Performance impact of record sizes
Дата
Msg-id
200207160449.g6G4n0l06741@candle.pha.pa.us
Ответ на
Re: Performance impact of record sizes (Bruce Momjian)
Список
Дерево обсуждения
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 по дате отправления