| 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-11 18:44:25 |
| Message-ID: | 20160211184425.mfjsqldrnjxklhu3@alap3.anarazel.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 2016-02-04 16:54:58 +0100, Andres Freund wrote:
> Fabien asked me to post a new version of the checkpoint flushing patch
> series. While this isn't entirely ready for commit, I think we're
> getting closer.
>
> 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 first two commits of the series are pretty close to being ready. I'd
welcome review of those, and I plan to commit them independently of the
rest as they're beneficial independently. The most important bits are
the comments and docs of 0002 - they weren't particularly good
beforehand, so I had to rewrite a fair bit.
0001: Make SetHintBit() a bit more aggressive, afaics that fixes all the
potential regressions of 0002
0002: Fix the overaggressive flushing by the wal writer, by only
flushing every wal_writer_delay ms or wal_writer_flush_after
bytes.
Greetings,
Andres Freund
| Attachment | Content-Type | Size |
|---|---|---|
| 0001-Allow-SetHintBits-to-succeed-if-the-buffer-s-LSN-is-.patch | text/x-patch | 3.2 KB |
| 0002-Allow-the-WAL-writer-to-flush-WAL-at-a-reduced-rate.patch | text/x-patch | 15.7 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2016-02-11 18:45:07 | Re: Performance degradation in commit ac1d794 |
| Previous Message | Tom Lane | 2016-02-11 18:41:20 | Re: Performance degradation in commit ac1d794 |