Re: PG and undo logging
От
Jan de Visser
Тема
Re: PG and undo logging
Дата
Msg-id
7899419.M41HPWkotP@wolverine
Ответ на
Re: PG and undo logging (David G. Johnston)
Список
Дерево обсуждения
PG and undo logging Ravi Krishna <sravikrishna3@gmail.com>
Re: PG and undo logging "David G. Johnston" <david.g.johnston@gmail.com>
Re: PG and undo logging Jan de Visser <jan@de-visser.net>
Re: PG and undo logging Ravi Krishna <sravikrishna3@gmail.com>
Re: PG and undo logging "David G. Johnston" <david.g.johnston@gmail.com>
Re: PG and undo logging Scott Marlowe <scott.marlowe@gmail.com>
Re: PG and undo logging Ravi Krishna <sravikrishna3@gmail.com>
Re: PG and undo logging Tom Lane <tgl@sss.pgh.pa.us>
On May 23, 2015 01:48:11 PM David G. Johnston wrote:
> On Sat, May 23, 2015 at 1:34 PM, Ravi Krishna <sravikrishna3@gmail.com>
>
> wrote:
> > Is it true that PG does not log undo information, only redo. If true,
> > then how does it bring a database back to consistent state during
> > crash recovery. Just curious.
>
> What does "undo" mean?
>
> David J.
Methinks rolling back the changes that transactions which got interrupted by the crash scribbled onto the data file. It's an Oracleism where not-consolidated data is kept in undo- and redo datafiles.
While I roughly understand Postgres' MVCC I don't feel qualified to answer Ravi's question :-)
В списке pgsql-general по дате отправления
От: Adrian Klaver
Дата:
