Re: How To Store Large Text Strings

From: Michael Lush <mjlush(at)gmail(dot)com>
To: Bartosz Dmytrak <bdmytrak(at)eranet(dot)pl>
Cc: Frank Bax <fbax(at)sympatico(dot)ca>, PostgreSQL List - Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: How To Store Large Text Strings
Date: 2012-03-09 08:33:50
Message-ID: CACXX7Mewf1rwEoob8MsMFcB_+4rPjWSFTaf1T6uFWCd2paB3JA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Fri, Mar 9, 2012 at 8:02 AM, Bartosz Dmytrak <bdmytrak(at)eranet(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Steve Horn 2012-03-10 01:51:54 float to numeric(7,3)
Previous Message Gavin Flower 2012-03-09 08:26:09 Re: How To Store Large Text Strings