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

Re: About TOAST and indices

From: JanWieck(at)t-online(dot)de (Jan Wieck)
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Jan Wieck <JanWieck(at)Yahoo(dot)com>, PostgreSQL HACKERS <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: About TOAST and indices
Date: 2000-07-20 16:41:16
Message-ID: 200007201641.SAA05485@hot.jw.home (view raw or flat)
Thread:
Lists: pgsql-hackers
Tom Lane wrote:
> JanWieck(at)t-online(dot)de (Jan Wieck) writes:
> >     So at the time  beeing,  I  think  index  tuples  should  not
> >     contain  any external toast references.
>
> Seems like a good stopgap solution.  You'll still allow them to be
> compressed in-line, though, right?

    Of  course. There's no problem with in-line compressed items.
    It's only these external references that cause trouble  after
    a vacuum.


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 #



In response to

pgsql-hackers by date

Next:From: Thomas LockhartDate: 2000-07-20 16:47:03
Subject: Re: How PostgreSQL's floating-point hurts everyone everywhere
Previous:From: Karel ZakDate: 2000-07-20 16:16:15
Subject: Re: locale changes

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