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

Re: TEXT or LONGTEXT?

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: 88daf38c0709240829u57361aa9yad96cc2e8dfaa3db@mail.gmail.com (view raw or flat)
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".

Alexander.

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-2014 The PostgreSQL Global Development Group