Re: checkpointer continuous flushing - V16 - Mailing list pgsql-hackers

From Andres Freund
Subject Re: checkpointer continuous flushing - V16
Date
Msg-id 20160208145416.hkrw5yvh7sepxft5@alap3.anarazel.de
Whole thread Raw
In response to Re: checkpointer continuous flushing - V16  (Andres Freund <andres@anarazel.de>)
Responses Re: checkpointer continuous flushing - V16  (Fabien COELHO <coelho@cri.ensmp.fr>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: WAL Re-Writes
Next
From: Robert Haas
Date:
Subject: Re: CustomScan in a larger structure (RE: CustomScan support on readfuncs.c)