Re: large text fields? - Mailing list pgsql-general

From Ron Peterson
Subject Re: large text fields?
Date
Msg-id 39478FD0.FA133344@yellowbank.com
Whole thread Raw
In response to large text fields?  (Mike Salib <msalib@MIT.EDU>)
Responses Re: large text fields?  (JanWieck@t-online.de (Jan Wieck))
List 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@yellowbank.com

pgsql-general by date:

Previous
From: Ron Peterson
Date:
Subject: Re: Postgresql and programming
Next
From: "Mirko Geffken"
Date:
Subject: Performance of PostgreSQL vs. Other DBs