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
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."
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 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 #
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
Import Notes
Reference msg id not found: Pine.BSF.4.21.0007182049290.1745-100000@thelab.hub.org | Resolved by subject fallback
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.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
==========================================================================
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 ...