Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: TEXT or LONGTEXT?
- From: Niklas Johansson <spot(at)tele2(dot)se>
- 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 18:00:29 +0200
On 24 sep 2007, at 17.21, Fabiola Fernández wrote:
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.
Postgres doesn't have a LONGTEXT datatype, so keep using TEXT. http://www.postgresql.org/docs/8.2/interactive/datatype-character.html Sincerely, Niklas Johansson
- 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: Searching for the cause of a bad plan
- Previous by thread: Re: TEXT or LONGTEXT?
- Next by thread: Acceptable level of over-estimation?
- Indexes: