Re: BUG #14345: run multi-PG9.6 on One Host, hang when checkpoint - Mailing list pgsql-bugs

From Andres Freund
Subject Re: BUG #14345: run multi-PG9.6 on One Host, hang when checkpoint
Date
Msg-id 20160930023337.vfbdqufvtg6mwc7i@alap3.anarazel.de
Whole thread Raw
In response to Re: BUG #14345: run multi-PG9.6 on One Host, hang when checkpoint  (德哥 <digoal@126.com>)
List pgsql-bugs
> But, PostgreSQL can also improve checkpoint to solve the problem
> (when checkpoint start, all bgwrite & backend process evict dirty page from buffer to disk ,can call
sync_file_range(syncmode), and checkpointer call fsync before ).     

I can't parse that sentence. Are you saying we should call
sync_file_range? If so, we do that starting in 9.6 for checkpoints (by
default) and background writer. If you do not want that to be called,
you also can disable it.

pgsql-bugs by date:

Previous
From: 德哥
Date:
Subject: Re: BUG #14345: run multi-PG9.6 on One Host, hang when checkpoint
Next
From: Michael Herold
Date:
Subject: COMMENT ON INDEX silently fails