| From: | Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> |
|---|---|
| To: | Patric Bechtel <patric(dot)bechtel(at)gmail(dot)com> |
| Cc: | PostgreSQL Developers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: checkpointer continuous flushing - V16 |
| Date: | 2016-02-19 20:08:44 |
| Message-ID: | alpine.DEB.2.10.1602192101270.3927@sto |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hallo Patric,
> Kernel 3.2 is extremely bad for Postgresql, as the vm seems to amplify
> IO somehow. The difference to 3.13 (the latest LTS kernel for 12.04) is
> huge.
>
> https://medium.com/postgresql-talk/benchmarking-postgresql-with-different-linux-kernel-versions-on-ubuntu-lts-e61d57b70dd4#.6dx44vipu
Interesting! To summarize it, 25% performance degradation from best kernel
(2.6.32) to worst (3.2.0), that is indeed significant.
> You might consider upgrading your kernel to 3.13 LTS. It's quite easy
> [...]
There are other stuff running on the hardware that I do not wish to touch,
so upgrading the particular host is currently not an option, otherwise I
would have switched to trusty.
Thanks for the pointer.
--
Fabien.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2016-02-19 20:09:58 | Re: pg_ctl promote wait |
| Previous Message | Tom Lane | 2016-02-19 20:08:40 | Re: pg_ctl promote wait |