Thread: TUPLE SIZE HELP
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."
>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
<blockquote cite="cite" type="cite">Though 8k is the default tuple size, you can change that number to be<br /> up to 32kAT COMPILE TIME. You can't, however, go above that size. <br /> The code base doesn't support a larger size. At thistime, you can<br /> either use Large Objects or wait a bit for the TOAST project to be<br /> finish (is there a maxfor that? 2G?)</blockquote><br /> How can I do this? Is there a -DEFINE or something?<br /><br /> Excuse my ignorance,there are things I SHOULD know...<br /><br /> Thomas<br /><br /><br /> - <br /> - <b><u>Thomas Swan</u></b> <br/> - Graduate Student - Computer Science<br /> - The University of Mississippi<br />- <br /> - "People can be categorized into two fundamental <br /> - groups, those that divide people into two groups <br/> - and those that don't."
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
>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."
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 theyear. Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== JanWieck@Yahoo.com #
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 ...
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 ==========================================================================
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
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 ...