Skip site navigation (1) Skip section navigation (2)

Re: How To Store Large Text Strings

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 (view raw or flat)
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>
>
>


In response to

pgsql-novice by date

Next:From: Frank LanitzDate: 2012-03-10 13:20:25
Subject: When to choose putting logic into PL/pgSQL and when to use an app server
Previous:From: Steve HornDate: 2012-03-10 01:51:54
Subject: float to numeric(7,3)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group