RE: Complete data erasure

Поиск
Список
Период
Сортировка
От asaba.takanori@fujitsu.com
Тема RE: Complete data erasure
Дата
Msg-id OSBPR01MB4728EE99EB295624643409C98C130@OSBPR01MB4728.jpnprd01.prod.outlook.com
обсуждение исходный текст
Ответ на Re: Complete data erasure  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы RE: Complete data erasure  ("asaba.takanori@fujitsu.com" <asaba.takanori@fujitsu.com>)
Список pgsql-hackers
Hello Tom,

From: Tom Lane <tgl@sss.pgh.pa.us>
> Tomas Vondra <tomas.vondra@2ndquadrant.com> writes:
> > I think it depends how exactly it's implemented. As Tom pointed out in
> > his message [1], we can't do the erasure itself in the post-commit is
> > not being able to handle errors. But if the files are renamed durably,
> > and the erasure happens in a separate process, that could be OK. The
> > COMMIT may wayt for it or not, that's mostly irrelevant I think.
>
> How is requiring a file rename to be completed post-commit any less
> problematic than the other way?  You still have a non-negligible
> chance of failure.

I think that errors of rename(2) listed in [1] cannot occur or can be handled.
What do you think?

[1] http://man7.org/linux/man-pages/man2/rename.2.html


Regards,

--
Takanori Asaba





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

Предыдущее
От: "asaba.takanori@fujitsu.com"
Дата:
Сообщение: RE: Complete data erasure
Следующее
От: Amit Langote
Дата:
Сообщение: Re: Autovacuum on partitioned table