Re: checkpointer continuous flushing - V16

From: Andres Freund <andres(at)anarazel(dot)de>
To: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
Cc: PostgreSQL Developers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: checkpointer continuous flushing - V16
Date: 2016-02-08 14:54:16
Message-ID: 20160208145416.hkrw5yvh7sepxft5@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2016-02-08 14:59:16 Re: CustomScan in a larger structure (RE: CustomScan support on readfuncs.c)
Previous Message Andres Freund 2016-02-08 14:46:40 Re: WAL Re-Writes