X-Original-To: pgsql-admin@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 1B2494761BC for ; Thu, 3 Apr 2003 14:26:49 -0500 (EST) Received: from stamp.musicrebellion.com (ns2.musicrebellion.com [12.109.75.243]) by postgresql.org (Postfix) with ESMTP id 8D0E2476036 for ; Thu, 3 Apr 2003 14:26:48 -0500 (EST) Received: from [10.0.0.102] (helo=musicrebellion.com ident=kris) by stamp.musicrebellion.com with esmtp (Exim 3.35 #1 (Debian)) id 191AMH-0001vo-00; Thu, 03 Apr 2003 14:26:45 -0500 Message-ID: <3E8C8AEC.607@musicrebellion.com> Date: Thu, 03 Apr 2003 14:26:36 -0500 From: Kris Kiger User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.0) Gecko/20020623 Debian/1.0.0-0.woody.1 X-Accept-Language: en MIME-Version: 1.0 To: Peter Eisentraut Cc: Juan Miguel , pgsql-admin@postgresql.org Subject: Re: Speed & Memory Management References: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Spam-Status: No, hits=-18.6 required=5.0 tests=BAYES_10,REFERENCES,USER_AGENT_MOZILLA_UA autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/44 X-Sequence-Number: 8199 Under what circumstances does a character not take up a set number of bytes? For example, i was under the impression that utf-8 allocated 6 bytes per character. While the character may not occupy all six bytes, each byte would still be reserved for that character set. Kris >Juan Miguel writes: > > > >>Well ... but ... reading database theory books, you can see that fixed size >>records are "better" than variant size records. >> >> > >Theory and practice are only the same in theory. In practice there is a >difference. > >Anyway, char(30) means 30 characters, not 30 bytes. So it's not a >fixed-size record anyway. Other factors are out-of-line storage and >automatic compression of long values. > > >