Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Mon, 24 Sep 2007 17:29:48 +0200
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.
- References:
- TEXT or LONGTEXT?
- From: Fabiola Fernández
- 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: TEXT or LONGTEXT?
- Next by thread: Re: TEXT or LONGTEXT?
- Indexes: