Re: large text fields?

From: Ron Peterson <rpeterson(at)yellowbank(dot)com>
To: Mike Salib <msalib(at)MIT(dot)EDU>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: large text fields?
Date: 2000-06-14 13:59:44
Message-ID: 39478FD0.FA133344@yellowbank.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Mike Salib wrote:
>
> Hi,
> I'm trying to find out if I can store more than 8k characters of data in
> one field in a single row. I'm working on a web based app and limiting
> myself to 8k posts is problematic. Has this limitation changed in
> Postgres 7?

No. You have three options, I think.

(1) Increase the data page size and recompile.

(2) Use the large object interface.

(3) Check out Jan Wieck's TOAST project
(http://www.postgresql.org/projects/devel-toast.html). It's still in
development, but maybe you can help.

________________________
Ron Peterson
rpeterson(at)yellowbank(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mirko Geffken 2000-06-14 14:06:08 Performance of PostgreSQL vs. Other DBs
Previous Message Ron Peterson 2000-06-14 13:47:32 Re: Postgresql and programming