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 19237D1B436; Mon,  8 Dec 2003 13:04:19 +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-06; Mon,  8 Dec 2003 09:03:51 -0400 (AST)
Received: from appsrv1.nuvergence.com (appsrv1.mgamble.ca [64.56.239.120])
	by svr1.postgresql.org (Postfix) with ESMTP
	id CD416D1B454; Mon,  8 Dec 2003 09:03:47 -0400 (AST)
Received: from DELL-P4
 (CPE000c418f70c3-CM400049675314.cpe.net.cable.rogers.com
	[24.112.136.107]) by appsrv1.nuvergence.com (Postfix) with ESMTP
	id 28EC730AE1C; Mon,  8 Dec 2003 08:03:28 -0500 (EST)
From: "Marc A. Leith" <marc@redboxdata.com>
To: "Ganesan Kanavathy" <ganesh@magnusquest.com>,
	"pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>,
	"pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
Date: Mon, 08 Dec 2003 08:03:12 -0500
X-Mailer: PMMail 2000 Professional (2.20.2717) For Windows 2000 (5.1.2600;1)
In-Reply-To: <007201c3bd8a$a930ccb0$5400a8c0@headquarters.mq.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="_=_=_=IMA.BOUNDARY.HTML_3985304=_=_=_"
Subject: Re: Field Size
Message-Id: <20031208130328.28EC730AE1C@appsrv1.nuvergence.com>
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=3.2 tagged_above=0.0 required=5.0 tests=HTML_10_20,
	HTML_FONT_COLOR_BLUE, HTML_FONT_COLOR_UNSAFE, HTML_FONT_FACE_ODD,
	IN_REP_TO, SUSPICIOUS_RECIPS
X-Spam-Level: ***
X-Archive-Number: 200312/83
X-Sequence-Number: 11591

--_=_=_=IMA.BOUNDARY.HTML_3985304=_=_=_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit

If you define the field as CHAR, 1000 bytes will be consumed.

If you define the field as VARCHAR, on sufficient bytes to store the contents will be used.

Marc

--Original Message Text---
From: Ganesan Kanavathy
Date: Mon, 8 Dec 2003 20:56:06 +0800

Clean Clean DocumentEmail MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-
colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-
orphan; font-size:10.0pt; font-family:"Times New Roman";} 

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  

   




Marc A. Leith
President
redboxdata inc.

e-mail: marc@redboxdata.com
cell:    (416) 737 0045


--_=_=_=IMA.BOUNDARY.HTML_3985304=_=_=_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: 7bit

<HTML>

<FONT FACE="MS Shell Dlg" DEFAULT="FACE"><FONT SIZE="1" POINTSIZE="8" DEFAULT="SIZE">If you define the field as CHAR, 1000 bytes will be consumed.<BR>

<BR>

If you define the field as VARCHAR, on sufficient bytes to store the contents will be used.<BR>

<BR>

Marc<BR>

<BR>

--Original Message Text---<BR>

<B>From:</B> Ganesan Kanavathy<BR>

<B>Date:</B> Mon, 8 Dec 2003 20:56:06 +0800<BR>

<BR>

Clean Clean DocumentEmail MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman";}<BR>

<BR>

<FONT FACE="Arial"><FONT SIZE="2" POINTSIZE="10">Can anyone tell me, what harm would setting a field size to <B>1000</B> characters do to the size?  <BR>

<BR>

   <BR>

<BR>

By increasing the size, will the database require more space? Or does it only consume space if there is data in the field only?  <BR>

<BR>

   <BR>

<BR>

Regards,  <BR>

<BR>

Ganesan  <BR>

<BR>

<FONT FACE="Times New Roman"><FONT SIZE="3" POINTSIZE="12">   <BR>

<BR>

<BR>


</HTML>

<HTML>
<LEFT>
<FONT FACE="MS Shell Dlg" COLOR="#000001" SIZE="1" POINTSIZE="8" DEFAULT="ALL">
<br>
Marc&nbsp;A.&nbsp;Leith<br>
President<br>
redboxdata&nbsp;inc.<br>
<br>
e-mail:&nbsp;marc@redboxdata.com<br>
cell:&nbsp;&nbsp;&nbsp;&nbsp;(416)&nbsp;737&nbsp;0045</HTML>

--_=_=_=IMA.BOUNDARY.HTML_3985304=_=_=_--