Re: Allowed to return possibly TOASTed datums? - Mailing list pgsql-general

From Tom Lane
Subject Re: Allowed to return possibly TOASTed datums?
Date
Msg-id 1472143.1734212250@sss.pgh.pa.us
Whole thread Raw
In response to Re: Allowed to return possibly TOASTed datums?  (Ron Johnson <ronljohnsonjr@gmail.com>)
List pgsql-general
Ron Johnson <ronljohnsonjr@gmail.com> writes:
> Since the purpose of TOAST is just (I think) to store "large field values"
> on disk by dividing into multiple chunks, what would be the purpose of
> returning the TOASTed value to Jan's function?

Probably not much.  There are scenarios where not detoasting
saves work overall, because the object never has to get detoasted;
but I think that's rare.  It'd probably look like

    UPDATE t SET c = no_op_function(c) WHERE ...

which is something few people would write.

            regards, tom lane



pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Allowed to return possibly TOASTed datums?
Next
From: Ron Johnson
Date:
Subject: Request for new column in pg_namespace