From: | Frank Bax <fbax(at)sympatico(dot)ca> |
---|---|
To: | |
Cc: | PostgreSQL List - Novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: How To Store Large Text Strings |
Date: | 2012-03-10 12:01:28 |
Message-ID: | 4F5B4298.8050205@sympatico.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
While I agree that max field size is 1G; I quoted "variable unlimited
length" from the postgresql website (see link below).
On 03/09/12 03:02, Bartosz Dmytrak wrote:
> Hi,
> It is not really unlimited (max 1GB):
>
> *Limit* *Value*
> Maximum Database Size Unlimited
> Maximum Table Size 32 TB
> Maximum Row Size 1.6 TB
> _*Maximum Field Size*_ _*1 GB*_
> Maximum Rows per Table Unlimited
> Maximum Columns per Table 250 - 1600 depending on column types
> Maximum Indexes per Table Unlimited
>
>
> http://www.postgresql.org/about/
>
> Regards,
> Bartek
>
>
> 2012/3/9 Frank Bax <fbax(at)sympatico(dot)ca <mailto:fbax(at)sympatico(dot)ca>>
>
> On 03/08/12 17:24, Jude Lucien wrote:
>
> What is the best way to store possible multiple-paragraph-sized
> strings of text?
>
> I had thought of just storing the hash but there is no guarentee
> that
> the hash will pop back into the same text.
>
>
>
> text (variable unlimited length)
>
> http://www.postgresql.org/__docs/9.0/static/datatype-__character.html <http://www.postgresql.org/docs/9.0/static/datatype-character.html>
>
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org
> <mailto:pgsql-novice(at)postgresql(dot)org>)
> To make changes to your subscription:
> http://www.postgresql.org/__mailpref/pgsql-novice
> <http://www.postgresql.org/mailpref/pgsql-novice>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Frank Lanitz | 2012-03-10 13:20:25 | When to choose putting logic into PL/pgSQL and when to use an app server |
Previous Message | Steve Horn | 2012-03-10 01:51:54 | float to numeric(7,3) |