Re: Partitioned checkpointing - Mailing list pgsql-hackers

From Fabien COELHO
Subject Re: Partitioned checkpointing
Date
Msg-id alpine.DEB.2.10.1509101131430.28533@sto
Whole thread Raw
In response to Partitioned checkpointing  (Takashi Horikawa <t-horikawa@aj.jp.nec.com>)
List pgsql-hackers
Hello Takashi-san,

I suggest that you have a look at the following patch submitted in June:
    https://commitfest.postgresql.org/6/260/

And these two threads:

http://www.postgresql.org/message-id/flat/alpine.DEB.2.10.1408251900211.11151@sto/
http://www.postgresql.org/message-id/flat/alpine.DEB.2.10.1506011320000.28433@sto/

Including many performance figures under different condition in the second 
thread. I'm not sure how it would interact with what you are proposing, 
but it is also focussing on improving postgres availability especially on 
HDD systems by changing how the checkpointer write buffers with sorting 
and flushing.

Also, you may consider running some tests about the latest version of this 
patch onto your hardware, to complement Amit tests?

-- 
Fabien.



pgsql-hackers by date:

Previous
From: Takashi Horikawa
Date:
Subject: Partitioned checkpointing
Next
From: Fabien COELHO
Date:
Subject: Re: Partitioned checkpointing