Re: TOAST & vacuum

> 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.

Seems this has some performance advantages.  Un-toasting to traverse a
btree index would be pretty slow.  This way, it is all in the index.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026