Re: tuples too big

From: Mitch Vincent <mvincent(at)venux(dot)net>
To: Michelle Murrain <mpm(at)norwottuck(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: tuples too big
Date: 2001-02-08 14:58:54
Message-ID: Pine.BSF.4.32.0102080956300.62781-100000@servbox.venux.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Well, I'd upgrade to at least 7.0.3 and change the BLCKSZ to 32k (in
src/include/config.h.in before configure config.h after).. That will give
you a 32k limit on tuple size.

7.1 eliminates the need for such things as TOAST does away with all tuple
size limits.. If you can wait, it should be out fairly soon.. I've been
using a 7.1 Beta 4 without a problem though I'm sure some bugs will
to pop up before the stable release..

Good luck!

-Mitch

On Thu, 8 Feb 2001, Michelle Murrain wrote:

> Hi folks,
>
> I've got a problem - I need a little help. I'm using 6.5.3 from Debian stable.
>
> I've got a database, which has some fields in one table that need to hold a
> fair bit of text (say, 8000-10,000+ characters). Right now, I've got those
> fields as simple text.
>
> When I try to enter data into those fields, I get the "Tuple too large"
> error.
>
> I can't chop up the fields into smaller pieces, and 8104 is not enough.
>
> Suggestions?
>
> Michelle
> --
> ------------
> Michelle Murrain, Ph.D.
> President
> Norwottuck Technology Resources
> mpm(at)norwottuck(dot)com
> http://www.norwottuck.com
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message martin.chantler 2001-02-08 15:06:53 Re: tuples too big
Previous Message Brice Ruth 2001-02-08 14:47:24 Re: monitoring running queries?