Thread: How To Store Large Text Strings

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.



--
"None are more hopelessly enslaved than those who falsely believe they
are free"  -- Johann Wolfgang von Goethe

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

On Fri, Mar 9, 2012 at 8:02 AM, Bartosz Dmytrak <bdmytrak@eranet.pl> wrote:
>
> Hi,
> It is not really unlimited (max 1GB):
> Maximum Columns per Table 250 - 1600 depending on column types

Though you can pretend to have many many more columns by using hstore
still have the 1GB field size limit though.

--
Michael

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@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

I don't believe that the maximum number of indexes is unlimited.   Just try creating an index for every permutation of 160 columns, which is about 4.71E284 different indexes.  It is simply not possible to house a computer big enough on Earth, and probably the known Universe is too small - not to mention minor details, like that even 64 bit integers would be far too small...  :-)

For practical purposes, I accept the statement - gracious aren't I???

You would have an incredibly slow database for updates and insertions way before you hit any practical limits on the number of indexes.

One gigabyte is more than enough to house the text of the biggest novel I have ever read - about 940 pages for 'Lorna Doone' (it was almost 50 years since I read it, so I might have misspelt the title).


Cheers,
Gavin

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@sympatico.ca <mailto: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
<http://www.postgresql.org/docs/9.0/static/datatype-character.html>
>
>
>     --
>     Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org
>     <mailto:pgsql-novice@postgresql.org>)
>     To make changes to your subscription:
>     http://www.postgresql.org/__mailpref/pgsql-novice
>     <http://www.postgresql.org/mailpref/pgsql-novice>
>
>