From: | Bartosz Dmytrak <bdmytrak(at)eranet(dot)pl> |
---|---|
To: | Frank Bax <fbax(at)sympatico(dot)ca> |
Cc: | PostgreSQL List - Novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: How To Store Large Text Strings |
Date: | 2012-03-09 08:02:27 |
Message-ID: | CAD8_UcZOkXz1vUy5LZupc8r6jUHn=_AKxOOVSHik=T7jmN-jCA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi,
It is not really unlimited (max 1GB):
*Limit* *Value*Maximum Database SizeUnlimitedMaximum Table Size32 TBMaximum
Row Size 1.6 TB*Maximum Field Size**1 GB*Maximum Rows per TableUnlimitedMaximum
Columns per Table250 - 1600 depending on column types Maximum Indexes per
TableUnlimited
http://www.postgresql.org/about/
Regards,
Bartek
2012/3/9 Frank Bax <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)
> 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 | Gavin Flower | 2012-03-09 08:26:09 | Re: How To Store Large Text Strings |
Previous Message | Frank Bax | 2012-03-09 01:19:59 | Re: How To Store Large Text Strings |