Re: large text fields - Mailing list pgsql-general

From Lamar Owen
Subject Re: large text fields
Date
Msg-id 38ECF217.56C9392D@wgcr.org
Whole thread Raw
In response to large text fields  ("Kevin Heflin" <kheflin@shreve.net>)
List pgsql-general
Kevin Heflin wrote:
>
> when ever I've dealt with a field that would require more text than 250
> characters, I've always used the 'text' datatype. It appears I've hit an
> example where this won't work. users are trying to insert what amounts to
> about 2 pages worth of text and I'm seeing this error:
>
> PostgresSQL query failed: ERROR: Tuple is too big: size 10000
>
> Are there any other options other than using a BLOB datatype ? which I'm
> completely unfamiliar with.

Recompile with a larger BLKSIZ of 16K or 32K. Or wait on TOAST.

--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

pgsql-general by date:

Previous
From: "Kevin Heflin"
Date:
Subject: large text fields
Next
From: "Ross J. Reedstrom"
Date:
Subject: Re: Functions in postgres