Horton

Thread

  1. TUPLE SIZE HELP

    Thomas Swan <tswan@olemiss.edu> — 2000-07-17T18:58:08Z

    I've tried doing as much reading on the mailing lists as I can on this.

The problem lies in that I'm trying to use PostgreSQL to store HTML 
documents which are larger than the default tuple size of 8120 bytes.   I 
originally thought that the data type TEXT wasn't limited in size.   Also, 
through some of the postings, I came to the understanding there was a 
limit, but that it was supposed to be removed.

I've gone through the source some and found where MaxTupleSize is defined, 
but I'm not sure what would be acceptable values to set it to.

Can anyone offer some help?

Thanks in advance,
Thomas
-
- Thomas Swan
- Graduate Student  - Computer Science
- The University of Mississippi
-
- "People can be categorized into two fundamental
- groups, those that divide people into two groups
- and those that don't."

  2. Re: TUPLE SIZE HELP

    B. Palmer <bpalmer@sixdegrees.com> — 2000-07-17T20:06:43Z

    >I've gone through the source some and found where MaxTupleSize is defined, 
>but I'm not sure what would be acceptable values to set it to.

Though 8k is the default tuple size,  you can change that number to be
up to 32k AT COMPILE TIME.  You can't,  however,  go above that size. 
The code base doesn't support a larger size.  At this time,  you can
either use Large Objects or wait a bit for the TOAST project to be
finish (is there a max for that?  2G?)

- Brandon
sixdegrees.com
w:  212.375.2688
c:  917.734.1981

  3. Re: TUPLE SIZE HELP

    Thomas Swan <tswan@olemiss.edu> — 2000-07-17T20:55:43Z

    >Though 8k is the default tuple size,  you can change that number to be
>up to 32k AT COMPILE TIME.  You can't,  however,  go above that size.
>The code base doesn't support a larger size.  At this time,  you can
>either use Large Objects or wait a bit for the TOAST project to be
>finish (is there a max for that?  2G?)

How can I do this?  Is there a -DEFINE or something?

Excuse my ignorance, there are things I SHOULD know...

Thomas


-
- Thomas Swan
- Graduate Student  - Computer Science
- The University of Mississippi
-
- "People can be categorized into two fundamental
- groups, those that divide people into two groups
- and those that don't."

  4. Re: TUPLE SIZE HELP

    Tom Lane <tgl@sss.pgh.pa.us> — 2000-07-17T21:35:37Z

    Thomas Swan <tswan@olemiss.edu> writes:
> I've gone through the source some and found where MaxTupleSize is defined, 
> but I'm not sure what would be acceptable values to set it to.

That would be the wrong thing to change in any case.  BLCKSZ in
include/config.h is the value you can twiddle.

			regards, tom lane

  5. Re: TUPLE SIZE HELP

    Thomas Swan <tswan@olemiss.edu> — 2000-07-17T21:56:28Z

    >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?


-
- Thomas Swan
- Graduate Student  - Computer Science
- The University of Mississippi
-
- "People can be categorized into two fundamental
- groups, those that divide people into two groups
- and those that don't."

  6. Re: TUPLE SIZE HELP

    Jan Wieck <janwieck@t-online.de> — 2000-07-18T09:10:28Z

    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.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #

  7. Re: TUPLE SIZE HELP

    Hannu Krosing <hannu@tm.ee> — 2000-07-18T23:36:47Z

    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

  8. Re: TUPLE SIZE HELP

    Marc G. Fournier <scrappy@hub.org> — 2000-07-18T23:50:19Z

    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 ...

  9. Re: TUPLE SIZE HELP

    Vince Vielhaber <vev@michvhf.com> — 2000-07-19T00:00:37Z

    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.net
 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking
        Online Campground Directory    http://www.camping-usa.com
       Online Giftshop Superstore    http://www.cloudninegifts.com
==========================================================================

  10. Re: TUPLE SIZE HELP

    Marc G. Fournier <scrappy@hub.org> — 2000-07-19T00:41:43Z

    On Wed, 19 Jul 2000, Hannu Krosing wrote:

> 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 ...

Correct ...