Re: PSA: If you are running Precise/12.04 upgrade your kernel.

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(at)commandprompt(dot)com> 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?
>
>