[HACKERS] Dumb user question re: updates, Toast, HOT

[Richard Huxton]

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

---(end of broadcast)---
TIP 6: explain analyze is your friend

Re: [HACKERS] Dumb user question re: updates, Toast, HOT

[Andrew - Supernews]

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

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings