Perhaps someone with a spare server floating around could install Ubuntu
LTS and run some pg-bench benchmarks with the various kernel options?
Like you, I'd have to stick to official updates for production systems.
-Toby
On 07/06/13 15:36, Nikhil G Daddikar wrote:
Folks,
This is bad news as I run Ubuntu 12.04 LTS. However, my ubuntu 12.04 LTS
boxes have been updated to "3.5.0-32-generic" (official update). Any
idea whether the Postgresql has problems with this kernel? I'd like to
follow the "official" LTS updates because I am not sure what other
surprises I could face if I move to an unofficial one.
Thanks!
Nikhil
On 07-06-2013 04:18, Scott Marlowe wrote:
On Thu, Jun 6, 2013 at 4:35 PM, Joshua D. Drake <jd@xxxxxxxxxxxxxxxxx>
wrote:
Hello,
I had the distinct displeasure of staying up entirely too late with a
customer this week because they upgraded to 12.04 and immediately
experienced a huge performance regression. In the process they also
upgraded
to PostgreSQL 9.1 from 8.4. There were a lot of knobs to
change/fix/modify
because of this. However, nothing I did fixed the problem. Until... I
upgraded the kernel.
Upgrading from 3.2Precise to the 3.9.4 kernel produced the following
results:
I've since heard that 3.4 also fixes this issue as well.
What are you using for your IO on these boxes?
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general