Skip site navigation (1) Skip section navigation (2)

Re: BLOB HOWTO??

From: Jan Wieck <janwieck(at)Yahoo(dot)com>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: ohp(at)pyrenet(dot)fr, pgsql-hackers(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: Re: BLOB HOWTO??
Date: 2001-01-29 18:10:37
Message-ID: 200101291810.NAA03883@jupiter.greatbridge.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-sql
Bruce Momjian wrote:
> > Hi Bruce,
> >
> > Any idea when it's due for??
>
> When?  Probably not until 7.2, which is a pain.

    We cannot use TOAST as is for BLOB/CLOB storage with a binary
    IO interface over fastpath.

    The reason is that you cannot force a column to be moved  off
    anyway  and  that  the  toast reference contains the original
    objects size.  Thus, opening a BLOB for writing would require
    the  reference  in  the  main  tuple to get updated and maybe
    moving off the data first.

    My plans for 7.2 are to use the toast table for storage,  but
    to build new data types with support hooks in the toaster for
    it.


Jan

--

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



_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


In response to

pgsql-hackers by date

Next:From: Jan WieckDate: 2001-01-29 18:12:47
Subject: Re: [SQL] Re: BLOB HOWTO??
Previous:From: Bruce MomjianDate: 2001-01-29 17:52:04
Subject: Size of TODO.detail

pgsql-sql by date

Next:From: Jan WieckDate: 2001-01-29 18:12:47
Subject: Re: [SQL] Re: BLOB HOWTO??
Previous:From: Keith PerryDate: 2001-01-29 17:55:24
Subject: Problem with Day of Week

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group