Skip site navigation (1) Skip section navigation (2)

Re: How To Store Large Text Strings

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 (view raw or flat)
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>
>

In response to

Responses

pgsql-novice by date

Next:From: Gavin FlowerDate: 2012-03-09 08:26:09
Subject: Re: How To Store Large Text Strings
Previous:From: Frank BaxDate: 2012-03-09 01:19:59
Subject: Re: How To Store Large Text Strings

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group