Re: TUPLE SIZE HELP - Mailing list pgsql-hackers

From Vince Vielhaber
Subject Re: TUPLE SIZE HELP
Date
Msg-id Pine.BSF.4.21.0007181959400.16930-100000@paprika.michvhf.com
Whole thread Raw
In response to Re: TUPLE SIZE HELP  (The Hermit Hacker <scrappy@hub.org>)
List pgsql-hackers
On Tue, 18 Jul 2000, The Hermit Hacker wrote:

> On Tue, 18 Jul 2000, Jan Wieck wrote:
> 
> > Thomas Swan wrote:
> > >
> > > >That would be the wrong thing to change in any case.  BLCKSZ in
> > > >include/config.h is the value you can twiddle.
> > >
> > > Are there any plans to remove this limitation from the TEXT datatype?  If
> > > so, do you know what version we might see this in?
> > 
> >     It  is  already  in  the current development tree and will be
> >     shipped with the next release, scheduled for end of the year.
> 
> Just a quick note ... with v7.x, you *can* use the lztext type to get by
> the limitation ... its a temporary fix, but I believe that Vince is using
> it for the web site for similar reasons to the original poster ...

You are correct.   The guide now fits into one tuple.

Vince.
-- 
==========================================================================
Vince Vielhaber -- KA8CSH    email: vev@michvhf.com    http://www.pop4.net128K ISDN from $22.00/mo - 56K Dialup from
$16.00/moat Pop4 Networking       Online Campground Directory    http://www.camping-usa.com      Online Giftshop
Superstore   http://www.cloudninegifts.com
 
==========================================================================





pgsql-hackers by date:

Previous
From: The Hermit Hacker
Date:
Subject: Re: TUPLE SIZE HELP
Next
From: "Mikheev, Vadim"
Date:
Subject: RE: btree split logic is fragile in the presence of lar ge index items