| 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: | 2007-09-24 15:29:48 |
| Message-ID: | 88daf38c0709240829u57361aa9yad96cc2e8dfaa3db@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Csaba Nagy | 2007-09-24 15:34:16 | Re: select count(*) performance (vacuum did not help) |
| Previous Message | Bill Moran | 2007-09-24 15:29:07 | Re: select count(*) performance (vacuum did not help) |