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

Поиск
Список
Период
Сортировка
От Andrew - Supernews
Тема Re: Dumb user question re: updates, Toast, HOT
Дата
Msg-id slrnelbv1a.1jd6.andrew+nonews@atlantis.supernews.net
обсуждение исходный текст
Ответ на Dumb user question re: updates, Toast, HOT  (Richard Huxton <dev@archonet.com>)
Список 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 по дате отправления:

Предыдущее
От: Devrim GUNDUZ
Дата:
Сообщение: Giving up multiple postmaster + RPM issue
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [JDBC] server process (PID 1188) exited with exit code -1073741819, 8.2 beta1