| From: | "asaba(dot)takanori(at)fujitsu(dot)com" <asaba(dot)takanori(at)fujitsu(dot)com> |
|---|---|
| To: | 'Tom Lane' <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>, "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>, Stephen Frost <sfrost(at)snowman(dot)net>, 'Masahiko Sawada' <masahiko(dot)sawada(at)2ndquadrant(dot)com>, "imai(dot)yoshikazu(at)fujitsu(dot)com" <imai(dot)yoshikazu(at)fujitsu(dot)com>, "'pgsql-hackers(at)postgresql(dot)org'" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | RE: Complete data erasure |
| Date: | 2020-02-20 08:29:35 |
| Message-ID: | OSBPR01MB4728EE99EB295624643409C98C130@OSBPR01MB4728.jpnprd01.prod.outlook.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hello Tom,
From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amit Langote | 2020-02-20 08:32:40 | Re: Autovacuum on partitioned table |
| Previous Message | asaba.takanori@fujitsu.com | 2020-02-20 08:27:14 | RE: Complete data erasure |