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 3673BD1B445; Mon, 8 Dec 2003 12:53:13 +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 10910-07; Mon, 8 Dec 2003 08:52:45 -0400 (AST) Received: from magnusquest.com (magnusquest.com [128.121.126.6]) by svr1.postgresql.org (Postfix) with ESMTP id 94E02D1B4A9; Mon, 8 Dec 2003 08:52:33 -0400 (AST) Received: from ganesan ([219.93.76.2]) by magnusquest.com (8.12.10/8.11.6) with ESMTP id hB8CqSSD051943; Mon, 8 Dec 2003 20:52:30 +0800 (MYT) From: "Ganesan Kanavathy" To: , Subject: Field Size Date: Mon, 8 Dec 2003 20:52:03 +0800 Message-ID: <006301c3bd8a$18976f60$5400a8c0@headquarters.mq.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0064_01C3BDCD.26BAAF60" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2627 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.5 tagged_above=0.0 required=5.0 tests=HTML_80_90 X-Spam-Level: X-Archive-Number: 200312/120 X-Sequence-Number: 11628 This is a multi-part message in MIME format. ------=_NextPart_000_0064_01C3BDCD.26BAAF60 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_0064_01C3BDCD.26BAAF60 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 the database require more space? Or does it only consume space if there is data in the field only?

 

Regards,

Ganesan

 

------=_NextPart_000_0064_01C3BDCD.26BAAF60--