Re: Dumb user question re: updates, Toast, HOT - Mailing list pgsql-hackers

From Andrew - Supernews
Subject Re: Dumb user question re: updates, Toast, HOT
Date
Msg-id slrnelbv1a.1jd6.andrew+nonews@atlantis.supernews.net
Whole thread Raw
In response to Dumb user question re: updates, Toast, HOT  (Richard Huxton <dev@archonet.com>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Devrim GUNDUZ
Date:
Subject: Giving up multiple postmaster + RPM issue
Next
From: Tom Lane
Date:
Subject: Re: [JDBC] server process (PID 1188) exited with exit code -1073741819, 8.2 beta1