Личный кабинет
Укажите e-mail, на который будет выслан код восстановления пароля.
На указанный вами адрес e-mail был выслан код подтверждения аккаунта. Введите полученный код для продолжения:
Введите новый пароль два раза:
On Mon, Oct 26, 2015 at 12:07 PM, Ashutosh Bapat <ashutosh.bapat@enterprisedb.com> wrote:On Mon, Oct 26, 2015 at 10:19 AM, Amit Kapila <amit.kapila16@gmail.com> wrote:I think Oracle just copies the changed part of old row to rollback segment.Also in Redo logs, it just writes the changed column value (both old andnew). So for the case we are discussing in this thread (one changedcolumn out of 200 columns), Oracle will just write the old value of thatcolumn in Redo and then in rollback segment, and write the new valuein Redo and then do the in-place update in heap row.In that case, readers would pay the penalty for constructing the row.Readers that have snapshot older than update-transaction needs topay such cost, otherwise all newer transactions can directly read frompage. Also not all old-transaction readers have to pay any such cost.
On Mon, Oct 26, 2015 at 10:19 AM, Amit Kapila <amit.kapila16@gmail.com> wrote:I think Oracle just copies the changed part of old row to rollback segment.Also in Redo logs, it just writes the changed column value (both old andnew). So for the case we are discussing in this thread (one changedcolumn out of 200 columns), Oracle will just write the old value of thatcolumn in Redo and then in rollback segment, and write the new valuein Redo and then do the in-place update in heap row.In that case, readers would pay the penalty for constructing the row.
I think Oracle just copies the changed part of old row to rollback segment.Also in Redo logs, it just writes the changed column value (both old andnew). So for the case we are discussing in this thread (one changedcolumn out of 200 columns), Oracle will just write the old value of thatcolumn in Redo and then in rollback segment, and write the new valuein Redo and then do the in-place update in heap row.
Not only that, such a design has an advantage that the bloat due toolder data won't be there.
В списке pgsql-hackers по дате отправления: