Re: Performance impact of record sizes - Mailing list pgsql-admin

From Bruce Momjian
Subject Re: Performance impact of record sizes
Date
Msg-id 200207160449.g6G4n0l06741@candle.pha.pa.us
Whole thread Raw
In response to Re: Performance impact of record sizes  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-admin
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 by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Performance impact of record sizes
Next
From: Tom Lane
Date:
Subject: Re: initdb failing - core dump