TEXT or LONGTEXT?

From: Fabiola Fernández <fabiola(dot)fg(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: TEXT or LONGTEXT?
Date: 2007-09-24 15:21:25
Message-ID: 66f6273e0709240821j50e89fe6o28c06daf4b0abfc5@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

--
Fabiola Fernández Gutiérrez
Grupo de Ingeniería Biomédica
Escuela Superior de Ingeniería
Camino de los Descubrimientos, s/n
Isla de la Cartuja
41092 Sevilla (Spain)
Tfno: +34 954487399
E-mail: fabiola(dot)fg(at)gmail(dot)com

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Bill Moran 2007-09-24 15:29:07 Re: select count(*) performance (vacuum did not help)
Previous Message Gábor Farkas 2007-09-24 15:14:27 Re: select count(*) performance (vacuum did not help)