Postgres Pro
Downloads
Home   >   mailing lists

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

From Niklas Johansson
Subject Re: TEXT or LONGTEXT?
Date
Msg-id 9FB84061-9D20-484F-BFBE-34910C3274DA@tele2.se
Whole thread Raw
In response to TEXT or LONGTEXT?  ("Fabiola Fernández" <fabiola.fg@gmail.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: "Dave Dutcher"
Date:
Subject: Re: select count(*) performance (vacuum did not help)
Next
From: Simon Riggs
Date:
Subject: Re: Searching for the cause of a bad plan