Postgres Pro
Downloads
Home   >   mailing lists

Re: How To Store Large Text Strings - Mailing list pgsql-novice

From Bartosz Dmytrak
Subject Re: How To Store Large Text Strings
Date
Msg-id CAD8_UcZOkXz1vUy5LZupc8r6jUHn=_AKxOOVSHik=T7jmN-jCA@mail.gmail.com
Whole thread Raw
In response to Re: How To Store Large Text Strings  (Frank Bax <fbax@sympatico.ca>)
Responses Re: How To Store Large Text Strings  (Michael Lush <mjlush@gmail.com>)
Re: How To Store Large Text Strings  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
Re: How To Store Large Text Strings  (Frank Bax <fbax@sympatico.ca>)
List pgsql-novice
Tree view
Hi,
It is not really unlimited (max 1GB):

LimitValue
Maximum Database SizeUnlimited
Maximum Table Size32 TB
Maximum Row Size1.6 TB
Maximum Field Size1 GB
Maximum Rows per TableUnlimited
Maximum Columns per Table250 - 1600 depending on column types
Maximum Indexes per TableUnlimited


Regards,
Bartek


2012/3/9 Frank Bax <fbax@sympatico.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


--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice

pgsql-novice by date:

Previous
From: Frank Bax
Date:
Subject: Re: How To Store Large Text Strings
Next
From: Michael Lush
Date:
Subject: Re: How To Store Large Text Strings