From: Marc A. Leith <marc@redboxdata.com>
To: Ganesan Kanavathy <ganesh@magnusquest.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
To: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: Re: Field Size
Date: Mon, 08 Dec 2003 08:03:12 -0500
Message-ID: <20031208130328.28EC730AE1C@appsrv1.nuvergence.com> (raw)
In-Reply-To: <007201c3bd8a$a930ccb0$5400a8c0@headquarters.mq.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: marc@redboxdata.com, ganesh@magnusquest.com, pgsql-admin@postgresql.org
Subject: Re: Field Size
In-Reply-To: <20031208130328.28EC730AE1C@appsrv1.nuvergence.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox