X-Original-To: pgsql-admin@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 68C65475CBC for ; Wed, 2 Apr 2003 13:00:36 -0500 (EST) Received: from THOR.goeci.com (thor.goeci.com [66.28.220.99]) by postgresql.org (Postfix) with ESMTP id B42DB474E44 for ; Wed, 2 Apr 2003 13:00:31 -0500 (EST) Received: by THOR.goeci.com with Internet Mail Service (5.5.2653.19) id <2A4GD5C6>; Wed, 2 Apr 2003 13:00:31 -0500 Message-ID: <2D92FEBFD3BE1346A6C397223A8DD3FC0921C3@THOR.goeci.com> From: Murthy Kambhampaty To: 'Peter Eisentraut' Cc: pgsql-admin@postgresql.org Subject: Re: Speed & Memory Management Date: Wed, 2 Apr 2003 13:00:28 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: text/plain; charset="iso-8859-1" X-Spam-Status: No, hits=-16.7 required=5.0 tests=BAYES_01,ORIGINAL_MESSAGE,QUOTED_EMAIL_TEXT, SIGNATURE_SHORT_SPARSE 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/24 X-Sequence-Number: 8179 This, and the message from Tom Lane, seem inconsistent with the documentation re "Character Types" (http://developer.postgresql.org/docs/postgres/datatype-character.html) which says: "Tip: There are no performance differences between these three types, apart from the increased storage size when using the blank-padded type." -----Original Message----- From: Peter Eisentraut [mailto:peter_e@gmx.net] Sent: Tuesday, April 01, 2003 16:42 To: Kris Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Speed & Memory Management Kris writes: > 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). That would buy you absolutely nothing. char() is not faster than text. Instead you would make everything slower because the system would constantly have to pad and trim your values and it would bloat the storage with the extra spaces. -- Peter Eisentraut peter_e@gmx.net ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster