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:
Соглашаюсь с условиями обработки персональных данных