Received: from bjke.com (firewall-user@ganymede.bjke.com [144.210.8.38]) by hub.org (8.9.1/8.9.1) with ESMTP id SAA19028 for ; Wed, 13 Jan 1999 18:36:19 -0500 (EST) (envelope-from djackson@cpsgroup.com) Received: by bjke.com; id RAA28304; Wed, 13 Jan 1999 17:35:36 -0600 (CST) Received: from cpsmail.cpsgroup.com(144.210.12.11) by gauntlet.bjke.com via smap (4.1) id xmaa28267; Wed, 13 Jan 99 17:35:35 -0600 Received: by cpsmail with Internet Mail Service (5.0.1458.49) id ; Wed, 13 Jan 1999 17:38:01 -0600 Message-ID: From: "Jackson, DeJuan" To: Guido.Goldstein@t-online.de, pgsql-sql@hub.org, Gregory Holston Subject: RE: [SQL] Text type Date: Wed, 13 Jan 1999 17:38:00 -0600 X-Priority: 3 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.0.1458.49) Content-Type: text/plain The current limit to a TEXT field is MAX_TUPLE_SIZE - TUPLE_OVERHEAD - ANY_OTHER_FIELD_SIZES_AND_OVERHEAD, which with no other fields in the table is just less than 8k. But this can be increased at compile time. It's set to 8k because that tends to be optimal page size for most of the OS's that are supported. -DEJ > -----Original Message----- > From: Guido.Goldstein@t-online.de [mailto:Guido.Goldstein@t-online.de] > Sent: Wednesday, January 13, 1999 7:40 AM > To: pgsql-sql@hub.org > Subject: Re: [SQL] Text type > > > > Hello! > > On Wed, 13 Jan 1999 08:56:19 +0100 (MET) > Remigiusz Sokolowski wrote: > > > > > > Hi List, > > > > > > What is the max size of the text type in characters, > preferable, or > > > bytes. > > > > > > Thanks, > > > > > > -Greg > > > > AFAIK this is 8KB > > Somewhat less then 8K, because one -record- has to fit into one page > (of 8K). AFAIK. > > Bye > Guido > -- > We're showing progress. Things are getting worse at a slower rate. >