Re: TEXT or LONGTEXT? - Mailing list pgsql-performance

From Alexander Staubo
Subject Re: TEXT or LONGTEXT?
Date
Msg-id 88daf38c0709240829u57361aa9yad96cc2e8dfaa3db@mail.gmail.com
Whole thread Raw
In response to TEXT or LONGTEXT?  ("Fabiola Fernández" <fabiola.fg@gmail.com>)
List pgsql-performance
On 9/24/07, Fabiola Fernández <fabiola.fg@gmail.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.

pgsql-performance by date:

Previous
From: Bill Moran
Date:
Subject: Re: select count(*) performance (vacuum did not help)
Next
From: Csaba Nagy
Date:
Subject: Re: select count(*) performance (vacuum did not help)