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: 2007-09-24 16:00:29
Message-ID: 9FB84061-9D20-484F-BFBE-34910C3274DA@tele2.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Simon Riggs 2007-09-24 17:55:22 Re: Searching for the cause of a bad plan
Previous Message Dave Dutcher 2007-09-24 15:37:42 Re: select count(*) performance (vacuum did not help)