Re: UNDO and in-place update

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: UNDO and in-place update
Дата
Msg-id 20161125175311.GA30116@momjian.us
обсуждение исходный текст
Ответ на Re: UNDO and in-place update  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: UNDO and in-place update
Список pgsql-hackers
On Thu, Nov 24, 2016 at 12:23:28PM -0500, Robert Haas wrote:
> I agree up to a point.  I think we need to design our own system as
> well as we can, not just copy what others have done.  For example, the
> design I sketched will work with all of PostgreSQL's existing index
> types.  You need to modify each AM in order to support in-place
> updates when a column indexed by that AM has been modified, and that's
> probably highly desirable, but it's not a hard requirement.

I feel you are going to get into the problem of finding the index entry
for the old row --- the same thing that is holding back more aggressive
WARM updates.

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

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +



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

Предыдущее
От: Corey Huinker
Дата:
Сообщение: Re: make default TABLESPACE belong to target table.
Следующее
От: Paul Ramsey
Дата:
Сообщение: User-defined Operator Pushdown and Collations