Re: How To Store Large Text Strings
От | Bartosz Dmytrak |
---|---|
Тема | Re: How To Store Large Text Strings |
Дата | |
Msg-id | CAD8_UcZOkXz1vUy5LZupc8r6jUHn=_AKxOOVSHik=T7jmN-jCA@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: How To Store Large Text Strings (Frank Bax <fbax@sympatico.ca>) |
Ответы |
Re: How To Store Large Text Strings
Re: How To Store Large Text Strings Re: How To Store Large Text Strings |
Список | pgsql-novice |
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 |
Regards,
Bartek
Bartek
2012/3/9 Frank Bax <fbax@sympatico.ca>
On 03/08/12 17:24, Jude Lucien wrote:text (variable unlimited length)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.
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 по дате отправления: