Re: checkpointer continuous flushing - V16

Hi Fabien,

On 2016-02-04 16:54:58 +0100, Andres Freund wrote:
> I don't want to post a full series right now, but my working state is
> available on
> http://git.postgresql.org/gitweb/?p=users/andresfreund/postgres.git;a=shortlog;h=refs/heads/checkpoint-flush
> git://git.postgresql.org/git/users/andresfreund/postgres.git checkpoint-flush
>
> The main changes are that:
> 1) the significant performance regressions I saw are addressed by
> changing the wal writer flushing logic
> 2) The flushing API moved up a couple layers, and now deals with buffer
> tags, rather than the physical files
> 3) Writes from checkpoints, bgwriter and files are flushed, configurable
> by individual GUCs. Without that I still saw the spiked in a lot of circumstances.
>
> There's also a more experimental reimplementation of bgwriter, but I'm
> not sure it's realistic to polish that up within the constraints of 9.6.

Any comments before I spend more time polishing this? I'm currently
updating docs and comments to actually describe the current state...

Andres