Re: WAL Bypass for indexes - Mailing list pgsql-hackers

From Nicolas Barbier
Subject Re: WAL Bypass for indexes
Date
Msg-id b0f3f5a10604070641u59df9f00hec2f0e7d4b26d7f6@mail.gmail.com
Whole thread Raw
In response to Re: WAL Bypass for indexes  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: WAL Bypass for indexes
List pgsql-hackers
2006/4/3, Tom Lane <tgl@sss.pgh.pa.us>:

> "Jonah H. Harris" <jonah.harris@gmail.com> writes:
> > we're working on a prototype to reduce WAL I/O and index updates in a
> > large percentage of OLTP situations by employing an update-in-place
> > under *safe* conditions.
>
> AFAICS there are no circumstances, ever, in which update-in-place is
> "safe".  (No transaction can guarantee that it will commit.)

Updates to row values that did not "escape" the currect transaction
yet (ie, rows that were created by or have their last value written by
the current transaction).

Nicolas

--
Nicolas Barbier
http://www.gnu.org/philosophy/no-word-attachments.html


pgsql-hackers by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: GIN - Generalized Inverted iNdex.
Next
From: Oleg Bartunov
Date:
Subject: Re: GIN - Generalized Inverted iNdex.