On 2006-09-07, Gregory Stark <stark(at)enterprisedb(dot)com> wrote:
> Consider this real table definition I found in a few moments searching for
> schemas on google:
[snip table with lots of fixed-length char fields]
>
> By my count postgres would use 154 bytes for this record. Whereas in fact
> there's no need for it to take more than 87 bytes.
Are you sure? Perhaps you are assuming that a char(1) field can be made
to be fixed-length; this is not the case (consider utf-8 for example).
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services