Re: crash-safe visibility map, take three

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: crash-safe visibility map, take three
Дата
Msg-id
27659.1291135033@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
crash-safe visibility map, take three Robert Haas <robertmhaas@gmail.com>
Re: crash-safe visibility map, take three Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: crash-safe visibility map, take three Tom Lane <tgl@sss.pgh.pa.us>
Re: crash-safe visibility map, take three Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: crash-safe visibility map, take three Tom Lane <tgl@sss.pgh.pa.us>
Re: crash-safe visibility map, take three Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: crash-safe visibility map, take three Tom Lane <tgl@sss.pgh.pa.us>
Re: crash-safe visibility map, take three Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: crash-safe visibility map, take three Tom Lane <tgl@sss.pgh.pa.us>
Re: crash-safe visibility map, take three Robert Haas <robertmhaas@gmail.com>
Re: crash-safe visibility map, take three Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: crash-safe visibility map, take three Robert Haas <robertmhaas@gmail.com>
Re: crash-safe visibility map, take three Tom Lane <tgl@sss.pgh.pa.us>
Re: crash-safe visibility map, take three Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: crash-safe visibility map, take three Bruce Momjian <bruce@momjian.us>
Re: crash-safe visibility map, take three Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: crash-safe visibility map, take three Bruce Momjian <bruce@momjian.us>
Re: crash-safe visibility map, take three Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: crash-safe visibility map, take three Bruce Momjian <bruce@momjian.us>
Re: crash-safe visibility map, take three Robert Haas <robertmhaas@gmail.com>
Re: crash-safe visibility map, take three Jeff Davis <pgsql@j-davis.com>
Re: crash-safe visibility map, take three Robert Haas <robertmhaas@gmail.com>
Re: crash-safe visibility map, take three Jeff Davis <pgsql@j-davis.com>
Re: crash-safe visibility map, take three Robert Haas <robertmhaas@gmail.com>
Re: crash-safe visibility map, take three Jeff Davis <pgsql@j-davis.com>
Re: crash-safe visibility map, take three "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: crash-safe visibility map, take three Robert Haas <robertmhaas@gmail.com>
Re: crash-safe visibility map, take three Jeff Davis <pgsql@j-davis.com>
Re: crash-safe visibility map, take three Robert Haas <robertmhaas@gmail.com>
Re: crash-safe visibility map, take three Jeff Davis <pgsql@j-davis.com>
Re: crash-safe visibility map, take three Dimitri Fontaine <dimitri@2ndQuadrant.fr>
Re: crash-safe visibility map, take three Robert Haas <robertmhaas@gmail.com>
Re: crash-safe visibility map, take three Tom Lane <tgl@sss.pgh.pa.us>
Re: crash-safe visibility map, take three Jim Nasby <jim@nasby.net>
Re: crash-safe visibility map, take three Robert Haas <robertmhaas@gmail.com>
Re: crash-safe visibility map, take three Florian Weimer <fweimer@bfk.de>
Re: crash-safe visibility map, take three Tom Lane <tgl@sss.pgh.pa.us>
Re: crash-safe visibility map, take three Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: crash-safe visibility map, take three Tom Lane <tgl@sss.pgh.pa.us>
Re: crash-safe visibility map, take three Tom Lane <tgl@sss.pgh.pa.us>
Re: crash-safe visibility map, take three Robert Haas <robertmhaas@gmail.com>
Re: crash-safe visibility map, take three Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: crash-safe visibility map, take three Tom Lane <tgl@sss.pgh.pa.us>
Re: crash-safe visibility map, take three Robert Haas <robertmhaas@gmail.com>
Re: crash-safe visibility map, take three "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: crash-safe visibility map, take three Robert Haas <robertmhaas@gmail.com>
Re: crash-safe visibility map, take three Tom Lane <tgl@sss.pgh.pa.us>
Re: crash-safe visibility map, take three Robert Haas <robertmhaas@gmail.com>
Re: crash-safe visibility map, take three Tom Lane <tgl@sss.pgh.pa.us>
Re: crash-safe visibility map, take three Robert Haas <robertmhaas@gmail.com>
Re: crash-safe visibility map, take three Tom Lane <tgl@sss.pgh.pa.us>
Re: crash-safe visibility map, take three Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: crash-safe visibility map, take three Tom Lane <tgl@sss.pgh.pa.us>
Re: crash-safe visibility map, take three Robert Haas <robertmhaas@gmail.com>
Re: crash-safe visibility map, take three Robert Haas <robertmhaas@gmail.com>
Re: crash-safe visibility map, take three Robert Haas <robertmhaas@gmail.com>
Re: crash-safe visibility map, take three Robert Haas <robertmhaas@gmail.com>
Re: crash-safe visibility map, take three Robert Haas <robertmhaas@gmail.com>
Re: crash-safe visibility map, take three Robert Haas <robertmhaas@gmail.com>
Re: crash-safe visibility map, take three Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: crash-safe visibility map, take three Robert Haas <robertmhaas@gmail.com>
Re: crash-safe visibility map, take three Tom Lane <tgl@sss.pgh.pa.us>
Re: crash-safe visibility map, take three Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: crash-safe visibility map, take three Robert Haas <robertmhaas@gmail.com>
Re: crash-safe visibility map, take three Tom Lane <tgl@sss.pgh.pa.us>
Re: crash-safe visibility map, take three Robert Haas <robertmhaas@gmail.com>
Re: crash-safe visibility map, take three Jesper Krogh <jesper@krogh.cc>
Re: crash-safe visibility map, take three Robert Haas <robertmhaas@gmail.com>
Re: crash-safe visibility map, take three Jesper Krogh <jesper@krogh.cc>
Re: crash-safe visibility map, take three Jim Nasby <jim@nasby.net>
Re: crash-safe visibility map, take three Robert Haas <robertmhaas@gmail.com>
Re: crash-safe visibility map, take three Rob Wultsch <wultsch@gmail.com>
Heikki Linnakangas  writes:
> On 30.11.2010 18:10, Tom Lane wrote:
>> I'm not convinced it works at all.  Consider write intent record,
>> checkpoint, set bit, crash before completing vacuum.  There will be
>> no second intent record at which you could clean up if things are
>> inconsistent.

> That's why you need to check the RedoRecPtr when you set the bit. If it 
> has changed, ie. a checkpoint has happened, the set bit step will write 
> a new intent record.

Oh, you explained the proposal poorly then.  I thought you meant recheck
and write another intent record just once, immediately before sending
the final xlog record.

It still seems rickety and not clearly correct, especially when you
start thinking about all the other constraints we have on xlog behavior
(eg, does this work while taking a base backup).
		regards, tom lane

В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата:
От: Greg Smith
Дата:
FAQ