Re: TUPLE SIZE HELP - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: TUPLE SIZE HELP
Date
Msg-id 3974EA0F.3EE8000B@tm.ee
Whole thread Raw
In response to Re: TUPLE SIZE HELP  (The Hermit Hacker <scrappy@hub.org>)
Responses Re: TUPLE SIZE HELP  (The Hermit Hacker <scrappy@hub.org>)
List pgsql-hackers
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 ...

IIRC lztext does only compression and not splitting, so it just gets you
so far ...

-------
Hannu


pgsql-hackers by date:

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