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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers