From: wieck@debis.com
To: wieck@debis.com
Cc: mitch@venux.net
Cc: pgsql-sql@postgreSQL.org
Subject: Re: [SQL] Dilema.
Date: Sat, 11 Dec 1999 01:29:42 +0100 (MET)
Message-ID: <m11waPv-0003kGC@orion.SAPserv.Hamburg.dsh.de> (raw)
In-Reply-To: <m11wa0d-0003kGC@orion.SAPserv.Hamburg.dsh.de>
I wrote:
> Look at this:
>
> pgsql=> select key, length(content) from bttest;
> key | length
> -----+--------
> 1 | 3
> 2 | 9
> 4 | 135840
> (3 rows)
Rereading my own comment, I just realized that it would be
possible to add a real BIG text type with a slightly
different technique. This would require another (not
syscached) pg_ relation plus support in heap access and some
other parts. And it would be a DEFINITELY NOT indexable
type. Also it would be subject to get removed someday after
we implemented large tuples.
But it would drop the pressure from the large tuple item
close to zero IMHO. So if I can implement it in a way, that
ensures it is easily removable again, why not?
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#========================================= wieck@debis.com (Jan Wieck) #
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: wieck@debis.com, mitch@venux.net
Subject: Re: [SQL] Dilema.
In-Reply-To: <m11waPv-0003kGC@orion.SAPserv.Hamburg.dsh.de>
References: <m11wa0d-0003kGC@orion.SAPserv.Hamburg.dsh.de> <m11waPv-0003kGC@orion.SAPserv.Hamburg.dsh.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox