Re: Update table performance

Поиск
Список
Период
Сортировка
От Decibel!
Тема Re: Update table performance
Дата
Msg-id 20070809153215.GQ20424@nasby.net
обсуждение исходный текст
Ответ на Re: Update table performance  ("Merlin Moncure" <mmoncure@gmail.com>)
Список pgsql-performance
On Thu, Aug 09, 2007 at 06:04:09PM +0530, Merlin Moncure wrote:
> That said, 'update' is the slowest operation for postgresql relative
> to other databases that are not MVCC.

Actually, it depends on how you do MVCC. In Oracle, DELETE is actually
the most expensive operation, because they have to not only remove the
row from the heap, they have to copy it to the undo log. And they need
to do something with indexes as well. Whereas we just update 4 bytes in
the heap and that's it.

An UPDATE in Oracle OTOH just needs to store whatever fields have
changed in the undo log. If you haven't messed with indexed fields, it
doesn't have to touch those either.
--
Decibel!, aka Jim Nasby                        decibel@decibel.org
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

Вложения

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

Предыдущее
От: Vivek Khera
Дата:
Сообщение: Re: mid 2007 "best bang for the buck" hardware opinions
Следующее
От: Joe Uhl
Дата:
Сообщение: Dell Hardware Recommendations