Re: Efficient slicing/substring of TOAST values (for comment)

John, do you have an updated version of this patch that is ready to be
applied to 7.3?

---------------------------------------------------------------------------

John Gray wrote:
> Hi all,
>
> I attach a patch which adds access routines for efficient extraction of
> parts of TOAST values.
>
> The principal additions are two routines in tuptoaster.c,
> heap_tuple_untoast_attr_slice and toast_fetch_datum_slice. The latter
> uses extra index scankeys to retrieve only the TOAST chunks which
> contain the requested substring. This will provide a performance benefit
> if you repeatedly extract small portions (e.g. file headers) from
> TOASTed values, as only one or two chunks will need to be fetched. This
> function is only invoked for external, uncompressed storage.
>

--
  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, Pennsylvania 19026