pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Andrea Suisani <sickpig@opinioni.net>
To: pgsql-performance@postgresql.org
Subject: Re: 20% performance drop on PostgreSQL 9.2 from kernel 3.5.3 to 3.6-rc5 on AMD chipsets
Date: Tue, 18 Sep 2012 09:44:13 +0200
Message-ID: <5058264D.5090702@opinioni.net> (raw)
In-Reply-To: <CAAZKuFbpifOgV3XCENTvkP30VCb0rOBv799D2_srJ6ujCACtkQ@mail.gmail.com>
References: <CA+Medizd1nfzQfC284x2-BwsCz+M80YZ6NfRMcXtKhPDdD1KqQ@mail.gmail.com>
	<CAAZKuFbpifOgV3XCENTvkP30VCb0rOBv799D2_srJ6ujCACtkQ@mail.gmail.com>

On 09/14/2012 10:45 AM, Daniel Farina wrote:
> On Fri, Sep 14, 2012 at 12:40 AM, Nikolay Ulyanitsky <lystor@gmail.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

it seems that kernel dev were able to find the root cause
after bisecting kernel source.

Borislav Petkov says that regression disappears
after reverting this commit:

commit 970e178985cadbca660feb02f4d2ee3a09f7fdda
Author: Mike Galbraith <efault@gmx.de>
Date:   Tue Jun 12 05:18:32 2012 +0200



Andrea












view thread (10+ messages)  latest in thread

Message-ID: <5058264D.5090702@opinioni.net>
Permalink:  ../5058264D.5090702@opinioni.net/
Also on:    postgresql.org/message-id/5058264D.5090702@opinioni.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: sickpig@opinioni.net
  Subject: Re: 20% performance drop on PostgreSQL 9.2 from kernel 3.5.3 to 3.6-rc5 on AMD chipsets
  In-Reply-To: <5058264D.5090702@opinioni.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox