Re: Allowed to return possibly TOASTed datums?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Allowed to return possibly TOASTed datums?
Дата
Msg-id 1472143.1734212250@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Allowed to return possibly TOASTed datums?  (Ron Johnson <ronljohnsonjr@gmail.com>)
Список 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 по дате отправления: