On 2006-09-07, Gregory Stark <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
