column size and storage efficiency - Mailing list pgsql-novice

From Bruce Hyatt
Subject column size and storage efficiency
Date
Msg-id 537954.58011.qm@web34402.mail.mud.yahoo.com
Whole thread Raw
Responses Re: column size and storage efficiency
List pgsql-novice
My inclination when creating tables is to create columns using varchar-sizes in increments of 10 or 5 but I suspect
theremust 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




pgsql-novice by date:

Previous
From: "Luiz K. Matsumura"
Date:
Subject: Re: Deferrerable Check constraints
Next
From: "Sean Davis"
Date:
Subject: Re: column size and storage efficiency