X-Original-To: pgsql-admin@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id BD5DD475AA9 for ; Mon, 31 Mar 2003 17:08:27 -0500 (EST) Received: from news.hub.org (news.hub.org [64.49.215.80]) by postgresql.org (Postfix) with ESMTP id 3B84B47580B for ; Mon, 31 Mar 2003 17:08:26 -0500 (EST) Received: by news.hub.org (Postfix, from userid 8) id 2764743A89E; Mon, 31 Mar 2003 17:08:26 -0500 (EST) From: "Kris" X-Newsgroups: comp.databases.postgresql.admin Subject: Speed & Memory Management Date: Mon, 31 Mar 2003 17:08:26 -0500 Organization: Hub.Org Networking Services (http://www.hub.org) Lines: 17 Message-ID: X-Complaints-To: usenet@news.hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 To: pgsql-admin@postgresql.org X-Spam-Status: No, hits=-5.2 required=5.0 tests=BAYES_10,PRIORITY_NO_NAME version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/4 X-Sequence-Number: 8159 Hello all. I am designing a database that will could potentially grow to have millions of tuples associated with it. My thought is that because I will likely have many updates/inserts/deletes occurring I should set each column that requires text to a static ammount (ie using char(30) instead of text). However, this looks to be a double edged sword, since selecting from the db is my largest concern (with updates a very close second). When I pull these values back out of the db, it seems I am going to have to trim each returned value (when I pull a ten character string out of this field, it returns the 10 char string as well as 20 whitespaces.). I am trying to assign a weight to each of these scenarios and figure out which is the lesser of the two evils. If anyone has a suggestion of how I may circumvent this issue or which possibility may work best, it would be greatly appreciated. Thanks Kris