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  (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>)
Список pgsql-novice
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 по дате отправления:

Предыдущее
От: Frank Bax
Дата:
Сообщение: Re: How To Store Large Text Strings
Следующее
От: Michael Lush
Дата:
Сообщение: Re: How To Store Large Text Strings