> 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