column size and storage efficiency

From: Bruce Hyatt <brucejhyatt(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: column size and storage efficiency
Date: 2008-11-26 01:51:16
Message-ID: 537954.58011.qm@web34402.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

My inclination when creating tables is to create columns using varchar-sizes in increments of 10 or 5 but I suspect there must be more-efficient sizes, specifically, values like 16, 32, 64 minus header-bits.

- Is this true? Does it really have much impact on storage?
- How many bits are the headers?
- How does TOAST factor in?

Thanks,
Bruce Hyatt

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Sean Davis 2008-11-26 02:08:18 Re: column size and storage efficiency
Previous Message Luiz K. Matsumura 2008-11-24 22:51:58 Re: Deferrerable Check constraints