Skip site navigation (1) Skip section navigation (2)


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: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance

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


pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group