| From: | Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> |
|---|---|
| To: | Takashi Horikawa <t-horikawa(at)aj(dot)jp(dot)nec(dot)com> |
| Cc: | "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Partitioned checkpointing |
| Date: | 2015-09-10 09:59:58 |
| Message-ID: | alpine.DEB.2.10.1509101131430.28533@sto |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)DEB(dot)2(dot)10(dot)1408251900211(dot)11151(at)sto/
http://www.postgresql.org/message-id/flat/alpine(dot)DEB(dot)2(dot)10(dot)1506011320000(dot)28433(at)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fabien COELHO | 2015-09-10 10:33:08 | Re: Partitioned checkpointing |
| Previous Message | Takashi Horikawa | 2015-09-10 09:12:39 | Partitioned checkpointing |