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

From: Andres Freund <andres(at)anarazel(dot)de>
To: 德哥 <digoal(at)126(dot)com>
Cc: Kevin Grittner <kgrittn(at)gmail(dot)com>, "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #14345: run multi-PG9.6 on One Host, hang when checkpoint
Date: 2016-09-30 02:33:37
Message-ID: 20160930023337.vfbdqufvtg6mwc7i@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(sync mode), 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.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Herold 2016-09-30 11:59:47 COMMENT ON INDEX silently fails
Previous Message 德哥 2016-09-30 02:27:17 Re: BUG #14345: run multi-PG9.6 on One Host, hang when checkpoint