pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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) #





view thread (5+ messages)  latest in thread

Message-ID: <m11waPv-0003kGC@orion.SAPserv.Hamburg.dsh.de>
Permalink:  ../m11waPv-0003kGC@orion.SAPserv.Hamburg.dsh.de/
Also on:    postgresql.org/message-id/m11waPv-0003kGC@orion.SAPserv.Hamburg.dsh.de

 · 

reply

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