Re: 20% performance drop on PostgreSQL 9.2 from kernel 3.5.3 to 3.6-rc5 on AMD chipsets

From: Andrea Suisani <sickpig(at)opinioni(dot)net>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: 20% performance drop on PostgreSQL 9.2 from kernel 3.5.3 to 3.6-rc5 on AMD chipsets
Date: 2012-10-03 11:45:54
Message-ID: 506C2572.2040505@opinioni.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi

On 09/18/2012 09:44 AM, Andrea Suisani wrote:
> On 09/14/2012 10:45 AM, Daniel Farina wrote:
>> On Fri, Sep 14, 2012 at 12:40 AM, Nikolay Ulyanitsky <lystor(at)gmail(dot)com> wrote:
>>> Hi
>>> I compiled the 3.6-rc5 kernel with the same config from 3.5.3 and got
>>> the 15-20% performance drop of PostgreSQL 9.2 on AMD chipsets (880G,
>>> 990X).
>
> [cut]
>
>>> Kernel config - http://pastebin.com/cFpg5JSJ
>>>
>>> Any ideas?
>>
>> Did you tell LKML? It seems like a kind of change that could be found
>> using git bisect of Linux, albiet laboriously.
>
>
> just a pointer to LKML thread:
>
> https://lkml.org/lkml/2012/9/14/99

[cut]

today Jonathan Corbet has posted a good write-up on lwn.net

"How 3.6 nearly broke PostgreSQL"

http://lwn.net/SubscriberLink/518329/672d5c68286f9c18/

this is definitely a worth reading piece.

Andrea

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Glyn Astill 2012-10-03 11:56:44 Re: hardware advice
Previous Message Nick Hofstede 2012-10-03 08:02:49 Re: suboptimal query plan