Re: [BUGS] Fails to work on live images due to fsync() onpg_commit_ts before doing any write there

Поиск
Список
Период
Сортировка
От Raphael Hertzog
Тема Re: [BUGS] Fails to work on live images due to fsync() onpg_commit_ts before doing any write there
Дата
Msg-id 20171107150602.yt7jrju2a2jhx6w4@home.ouaza.com
обсуждение исходный текст
Ответ на Re: [BUGS] Fails to work on live images due to fsync() onpg_commit_ts before doing any write there  (Stephen Frost <sfrost@snowman.net>)
Ответы Re: [BUGS] Fails to work on live images due to fsync() onpg_commit_ts before doing any write there  (Andres Freund <andres@anarazel.de>)
Список pgsql-bugs
On Tue, 07 Nov 2017, Stephen Frost wrote:
> Raphael,
> 
> * Raphael Hertzog (hertzog@debian.org) wrote:
> > Still I believe that this issue should be fixed in both sides. It's not
> > smart from PostgreSQL to call fsync() when it has not made any change.
> 
> Why?

Because it's useless. Why call fsync() when you know that it doesn't do
anything?

And because I have just shown that doing this can have unexpected
side-effects in some specific conditions.

But this is really a matter of aesthetics and trade-offs. I don't know the
code. It might be difficult to track the fact that changes have been made.

Cheers,
-- 
Raphaël Hertzog ◈ Debian Developer

Support Debian LTS: https://www.freexian.com/services/debian-lts.html
Learn to master Debian: https://debian-handbook.info/get/


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: [BUGS] Fails to work on live images due to fsync() onpg_commit_ts before doing any write there
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [BUGS] Fails to work on live images due to fsync() on pg_commit_ts before doing any write there