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

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(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?
>>
>>
>
>
>