TOAST & vacuum - Mailing list pgsql-hackers

From JanWieck@t-online.de (Jan Wieck)
Subject TOAST & vacuum
Date
Msg-id 200007211030.MAA03775@hot.jw.home
Whole thread Raw
Responses Re: TOAST & vacuum  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: TOAST & vacuum  (Bruce Momjian <pgman@candle.pha.pa.us>)
List 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 #




pgsql-hackers by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: How PostgreSQL's floating-point hurts everyone everywhere
Next
From: JanWieck@t-online.de (Jan Wieck)
Date:
Subject: Geometry test broken