Horton

TOAST & vacuum

Jan Wieck <janwieck@t-online.de>

View thread
From: JanWieck@t-online.de (Jan Wieck)
To: PostgreSQL HACKERS <pgsql-hackers@postgresql.org>
Date: 2000-07-21T10:30:36Z
Lists: pgsql-hackers 
FYI,

    TOAST  is now vacuum-safe. When needed, the toaster creates a
    second  heap  tuple,  containing  only  plain  or  compressed
    values.  This one is then returned by the heap access methods
    to  the  caller,  so  indices  will  never  contain  external
    references.

    The  changes  are  covered  by  #ifdef  TOAST_INDICES, so can
    easily be disabled at the time we have  file  versioning  and
    can recreate indices during vacuum.


Jan

--

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