Skip site navigation (1)
Skip section navigation (2)
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
Peripheral Links
Header And Logo
|
Site Navigation
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: Mon, 24 Sep 2007 17:21:25 +0200
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
- Follow-Ups:
- Re: TEXT or LONGTEXT?
- From: Niklas Johansson
- Re: TEXT or LONGTEXT?
- From: Alexander Staubo
- Re: TEXT or LONGTEXT?
- Prev by Date: Re: select count(*) performance (vacuum did not help)
- Next by Date: Re: select count(*) performance (vacuum did not help)
- Previous by thread: select count(*) performance (vacuum did not help)
- Next by thread: Re: TEXT or LONGTEXT?
- Indexes: