Thread: Dumb user question re: updates, Toast, HOT

The recent discussion on the proposed HOT scheme has reminded me of a 
question I meant to ask about TOASTing when it was introduced back in 7.1(?)

If I have a table something like: (id, status, big_text) and just update 
the "status" column on a row, do I have two copies of "big_text" TOASTED 
or are they shared?

--   Richard Huxton  Archonet Ltd

On 2006-11-11, Richard Huxton <dev@archonet.com> wrote:
> The recent discussion on the proposed HOT scheme has reminded me of a 
> question I meant to ask about TOASTing when it was introduced back in 7.1(?)
>
> If I have a table something like: (id, status, big_text) and just update 
> the "status" column on a row, do I have two copies of "big_text" TOASTED 
> or are they shared?

Shared.

-- 
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services