Re: checkpointer continuous flushing

From: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: PostgreSQL Developers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: checkpointer continuous flushing
Date: 2016-01-19 12:34:14
Message-ID: alpine.DEB.2.10.1601191301350.15654@sto
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


> synchronous_commit = off does make a significant difference.

Sure, but I had thought about that and kept this one...

I think I found one possible culprit: I automatically wrote 300 seconds
for checkpoint_timeout, instead of 30 seconds in your settings. I'll have
to rerun the tests with this (unreasonnable) figure to check whether I
really get a regression.

Other tests I ran with "reasonnable" settings on a large (scale=800) db
did not show any significant performance regression, up to know.

--
Fabien.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2016-01-19 12:42:02 Re: custom function for converting human readable sizes to bytes
Previous Message Michael Paquier 2016-01-19 12:14:57 Re: Move PinBuffer and UnpinBuffer to atomics