Re: [pgsql-hackers-win32] win32 performance - fsync question

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas DAZ SD
Тема Re: [pgsql-hackers-win32] win32 performance - fsync question
Дата
Msg-id 46C15C39FEB2C44BA555E356FBCD6FA40184D31C@m0114.s-mxs.net
обсуждение исходный текст
Список pgsql-hackers
> >Are you verifying that all the data that was committed was actually stored? Or
> >just verifying that the database works properly after rebooting?
>
> I verified the data.

Does pg startup increase the xid by some amount (say 1000 xids) after crash ?
Else I think you would also need to rollback a range of xids after
the crash, to see if you don't loose data by reusing and rolling back xids.

The risk is datapages reaching the disk before WAL, because the disk rearranges.
I think you would not notice such corruption (with pg_dump) unless you do the
range rollback.

Andreas


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

Предыдущее
От: Jeff Davis
Дата:
Сообщение: idea for concurrent seqscans
Следующее
От: Karel Zak
Дата:
Сообщение: Re: UTF8 or Unicode