Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id D9A2C9FA0A5 for ; Mon, 24 Sep 2007 12:21:29 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 44604-06-2 for ; Mon, 24 Sep 2007 12:21:26 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.235]) by postgresql.org (Postfix) with ESMTP id C03529FA08D for ; Mon, 24 Sep 2007 12:21:26 -0300 (ADT) Received: by wr-out-0506.google.com with SMTP id 68so518219wri for ; Mon, 24 Sep 2007 08:21:26 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; bh=XlZ2C4rNnDZqBT0jjZFF6xpyaZUYEgVb1mSeQAUuF4c=; b=Pl52VW5ejYw22SLdsEYGifNb+Gf0bMeUo9op8xRMq1jLuWyFmpYhSc+lYp4Q4zMbZXoF6qQ8IV67tnoqgNXPI5RB4Kpe7XhASyDAwvxF7QOkrMpL3mtXkzThy0oRZPdPJv70/7EneIdMhHInYwP8xMxBrnrvxS5pNZH3Op8zg/o= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type; b=APeNK4xkTJ6vPts9+banWHxuAknlXLOiFwpbWVS20idLYrVnGoOUzNhj5bOjAIS2PGlOzslpfmgYYiF+8AR/46cdaNtXPp2wVV2ZHPfbHESaNHE6sPyx6yP/cegyWAent1Spqq89HGFlU2Ax89xkeIQdZxTjn7o2Ov1jL2JMvHk= Received: by 10.142.153.8 with SMTP id a8mr1680606wfe.1190647285472; Mon, 24 Sep 2007 08:21:25 -0700 (PDT) Received: by 10.142.163.4 with HTTP; Mon, 24 Sep 2007 08:21:25 -0700 (PDT) Message-ID: <66f6273e0709240821j50e89fe6o28c06daf4b0abfc5@mail.gmail.com> Date: Mon, 24 Sep 2007 17:21:25 +0200 From: "=?ISO-8859-1?Q?Fabiola_Fern=E1ndez?=" To: pgsql-performance@postgresql.org Subject: TEXT or LONGTEXT? MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_3691_25932274.1190647285471" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/423 X-Sequence-Number: 26968 ------=_Part_3691_25932274.1190647285471 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hello, I have a database with an amount of tables and in several of them I have an attribute for a semantic definition, for which I use a field of type text. = I am trying to decide if it would be worth using LONGTEXT instead of TEXT, as maybe it would slow down the data insertion and extraction. I hope that you could help me. Thank you. --=20 Fabiola Fern=E1ndez Guti=E9rrez Grupo de Ingenier=EDa Biom=E9dica Escuela Superior de Ingenier=EDa Camino de los Descubrimientos, s/n Isla de la Cartuja 41092 Sevilla (Spain) Tfno: +34 954487399 E-mail: fabiola.fg@gmail.com ------=_Part_3691_25932274.1190647285471 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hello,

I have a database with an amount of tables and in several of= them I have an attribute for a semantic definition, for which I use a fiel= d of type text. I am trying to decide if it would be worth using LONGTEXT i= nstead of TEXT, as maybe it would slow down the data insertion and extracti= on. I hope that you could help me. Thank you.

--
Fabiola Fern=E1ndez Guti=E9rrez
Grupo de In= genier=EDa Biom=E9dica
Escuela Superior de Ingenier=EDa
Camino de los= Descubrimientos, s/n
Isla de la Cartuja
41092 Sevilla (Spain)
Tfn= o: +34 954487399
E-mail: fabiola.fg@gmail.com ------=_Part_3691_25932274.1190647285471--