Re: pgsql: Fill tuple before HeapSatisfiesHOTAndKeyUpdate

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: pgsql: Fill tuple before HeapSatisfiesHOTAndKeyUpdate
Дата
Msg-id 20130201172504.GB2371@momjian.us
обсуждение исходный текст
Ответ на pgsql: Fill tuple before HeapSatisfiesHOTAndKeyUpdate  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Ответы Re: pgsql: Fill tuple before HeapSatisfiesHOTAndKeyUpdate  (Andres Freund <andres@2ndquadrant.com>)
Список pgsql-committers
On Fri, Feb  1, 2013 at 01:50:02PM +0000, Álvaro Herrera wrote:
> Fill tuple before HeapSatisfiesHOTAndKeyUpdate
>
> Failing to do this results in almost all updates to system catalogs
> being non-HOT updates, because the OID column would differ (not having
> been set for the new tuple), which is an indexed column.
>
> While at it, make sure to set the tableoid early in both old and new
> tuples as well.  This isn't of much consequence, since that column is
> seldom (never?) indexed.
>
> Report and patch from Andres Freund.

Was this a new bug in 9.3?

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +


В списке pgsql-committers по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: pgsql: Fix typo in freeze_table_age implementation
Следующее
От: Andres Freund
Дата:
Сообщение: Re: pgsql: Fill tuple before HeapSatisfiesHOTAndKeyUpdate