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


From: "Alexander Staubo" <alex(at)purefiction(dot)net>
To: Fabiola Fernández <fabiola(dot)fg(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: TEXT or LONGTEXT?
Date: 2007-09-24 15:29:48
Message-ID: (view raw or whole thread)
Lists: pgsql-performance
On 9/24/07, Fabiola Fernández <fabiola(dot)fg(at)gmail(dot)com> wrote:
> 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.

Easy choice -- PostgreSQL does not have a data type named "longtext".


In response to

pgsql-performance by date

Next:From: Csaba NagyDate: 2007-09-24 15:34:16
Subject: Re: select count(*) performance (vacuum did not help)
Previous:From: Bill MoranDate: 2007-09-24 15:29:07
Subject: Re: select count(*) performance (vacuum did not help)

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