Re: Toast and slice of toast

From: Haribabu Kommi <kommi(dot)haribabu(at)gmail(dot)com>
To: Rémi Cura <remi(dot)cura(at)gmail(dot)com>
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Toast and slice of toast
Date: 2014-02-17 03:16:33
Message-ID: CAJrrPGdb3=gg+cG3Lm_fz_j0R9yW2ddTmkSBvJcUEzn2Xspo4g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, Feb 16, 2014 at 9:38 PM, Rémi Cura <remi(dot)cura(at)gmail(dot)com> wrote:

> Hey Dear List,
> could somebody point me to some ressources about getting only parts of
> toasted data?
>
> I have a very big custom type and I would like to take blocks of it (like
> byte A to B then byte C to D then... ).
>
> I found a function in http://doxygen.postgresql.org/tuptoaster_8c.html#called toast_fetch_datum_slice, is it the right way to use it
> (a for loop and calling it several time?).
>

"pg_detoast_datum_slice" is the function which will solve your problem.

Regards,
Hari Babu
Fujitsu Australia

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gabriel Sánchez Martínez 2014-02-17 03:33:10 avoiding file system caching of a table
Previous Message Ondřej Bouda 2014-02-16 18:17:57 Using pg_trigger.tgqual