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

From: Andrew - Supernews <andrew+nonews(at)supernews(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Dumb user question re: updates, Toast, HOT
Date: 2006-11-11 16:36:59
Message-ID: slrnelbv1a.1jd6.andrew+nonews@atlantis.supernews.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2006-11-11, Richard Huxton <dev(at)archonet(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-11-12 04:06:41 Re: [HACKERS] server process (PID 1188) exited with exit code -1073741819, 8.2 beta1
Previous Message Devrim GUNDUZ 2006-11-11 15:56:03 Giving up multiple postmaster + RPM issue