X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 94031D1B454; Mon, 8 Dec 2003 12:57:02 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 15075-02; Mon, 8 Dec 2003 08:56:33 -0400 (AST) Received: from magnusquest.com (magnusquest.com [128.121.126.6]) by svr1.postgresql.org (Postfix) with ESMTP id 24939D1B474; Mon, 8 Dec 2003 08:56:30 -0400 (AST) Received: from ganesan ([219.93.76.2]) by magnusquest.com (8.12.10/8.11.6) with ESMTP id hB8CuVEb052425; Mon, 8 Dec 2003 20:56:32 +0800 (MYT) From: "Ganesan Kanavathy" To: , Subject: Re: Field Size Date: Mon, 8 Dec 2003 20:56:06 +0800 Message-ID: <007201c3bd8a$a930ccb0$5400a8c0@headquarters.mq.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0073_01C3BDCD.B7540CB0" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2627 In-Reply-To: Importance: Normal X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.6 tagged_above=0.0 required=5.0 tests=HTML_80_90, HTML_FONT_COLOR_BLUE X-Spam-Level: X-Archive-Number: 200312/82 X-Sequence-Number: 11590 This is a multi-part message in MIME format. ------=_NextPart_000_0073_01C3BDCD.B7540CB0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Can anyone tell me, what harm would setting a field size to 1000 characters do to the size? By increasing the size, will the database require more space? Or does it only consume space if there is data in the field only? Regards, Ganesan ------=_NextPart_000_0073_01C3BDCD.B7540CB0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Can= anyone tell me, what harm would setting a field size to 1000 characters do to the size?

 

By increasing the size, will t= he database require more space? Or does it only consume space if there is data= in the field only?

 

Regards,=

Ganesan<= /o:p>

 

------=_NextPart_000_0073_01C3BDCD.B7540CB0--