Received: from magus.postgresql.org ([87.238.57.229]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TCXKJ-0003XL-TV for pgsql-performance@postgresql.org; Fri, 14 Sep 2012 14:57:04 +0000 Received: from ns3.uci.cu ([200.55.140.180] helo=mx3.uci.cu) by magus.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1TCXK7-00087C-J3 for pgsql-performance@postgresql.org; Fri, 14 Sep 2012 14:57:03 +0000 Received: (qmail 27114 invoked by uid 507); 14 Sep 2012 14:56:37 -0000 Received: from 10.0.0.188 by ns3.uci.cu (envelope-from , uid 501) with qmail-scanner-2.01st (avp: 5.0.2.0. spamassassin: 3.0.6. perlscan: 2.01st. Clear:RC:1(10.0.0.188):. Processed in 1.19956 secs); 14 Sep 2012 14:56:37 -0000 Received: from unknown (HELO ucimail5.uci.cu) (10.0.0.188) by 0 with SMTP; 14 Sep 2012 14:56:35 -0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by ucimail5.uci.cu (Postfix) with ESMTP id 75F5D2A4006 for ; Fri, 14 Sep 2012 10:56:35 -0400 (CDT) X-Virus-Scanned: amavisd-new at uci.cu Received: from ucimail5.uci.cu ([127.0.0.1]) by localhost (ucimail5.uci.cu [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 8b4qKCJZVFjW for ; Fri, 14 Sep 2012 10:56:30 -0400 (CDT) Received: by ucimail5.uci.cu (Postfix, from userid 101) id E18212A4007; Fri, 14 Sep 2012 10:56:30 -0400 (CDT) Received: from [10.56.18.124] (unknown [10.56.18.124]) (Authenticated sender: mlortiz@uci.cu) by ucimail5.uci.cu (Postfix) with ESMTPSA id C8C802A4004; Fri, 14 Sep 2012 10:56:30 -0400 (CDT) Message-ID: <5053459A.9030202@uci.cu> Date: Fri, 14 Sep 2012 10:56:26 -0400 From: Marcos Ortiz User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:13.0) Gecko/20120615 Thunderbird/13.0.1 MIME-Version: 1.0 To: Daniel Farina CC: Nikolay Ulyanitsky , 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 References: In-Reply-To: Content-Type: multipart/alternative; boundary="------------050201080608030008080201" X-Pg-Spam-Score: -2.4 (--) X-Archive-Number: 201209/66 X-Sequence-Number: 47812 This is a multi-part message in MIME format. --------------050201080608030008080201 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit Regards, Nikolay. Like Daniel said to you, I encourage to inform all your findings to the LKML to report all these problems. Only one las t question: Did you tune the postgresql.conf for every system? or Did you use the default configuration ? Best wishes On 09/14/2012 04:45 AM, Daniel Farina wrote: > On Fri, Sep 14, 2012 at 12:40 AM, Nikolay Ulyanitsky 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). >> >> CentOS 6.3 x86_64 >> PostgreSQL 9.2 >> cpufreq scaling_governor - performance >> >> # /etc/init.d/postgresql initdb >> # echo "fsync = off" >> /var/lib/pgsql/data/postgresql.conf >> # /etc/init.d/postgresql start >> # su - postgres >> $ psql >> # create database pgbench; >> # \q >> >> # pgbench -i pgbench && pgbench -c 10 -t 10000 pgbench >> tps = 4670.635648 (including connections establishing) >> tps = 4673.630345 (excluding connections establishing)[/code] >> >> On kernel 3.5.3: >> tps = ~5800 >> >> 1) Host 1 - 15-20% performance drop >> AMD Phenom(tm) II X6 1090T Processor >> MB: AMD 880G >> RAM: 16 Gb DDR3 >> SSD: PLEXTOR PX-256M3 256Gb >> >> 2) Host 2 - 15-20% performance drop >> AMD Phenom(tm) II X6 1055T Processor >> MB: AMD 990X >> RAM: 32 Gb DDR3 >> SSD: Corsair Performance Pro 128Gb >> >> 3) Host 3 - no problems - same performance >> Intel E6300 >> MB: Intel® P43 / ICH10 >> RAM: 4 Gb DDR3 >> HDD: SATA 7200 rpm >> >> 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. > -- Marcos Luis Ortíz Valmaseda *Data Engineer && Sr. System Administrator at UCI* about.me/marcosortiz My Blog Tumblr's blog @marcosluis2186 10mo. ANIVERSARIO DE LA CREACION DE LA UNIVERSIDAD DE LAS CIENCIAS INFORMATICAS... CONECTADOS AL FUTURO, CONECTADOS A LA REVOLUCION http://www.uci.cu http://www.facebook.com/universidad.uci http://www.flickr.com/photos/universidad_uci --------------050201080608030008080201 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Regards, Nikolay.
Like Daniel said to you, I encourage to inform all your findings to the LKML to
report all these problems.

Only one las t question: Did you tune the postgresql.conf for every system? or
Did you use the default configuration ?

Best wishes
On 09/14/2012 04: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).

CentOS 6.3 x86_64
PostgreSQL 9.2
cpufreq scaling_governor - performance

# /etc/init.d/postgresql initdb
# echo "fsync = off" >> /var/lib/pgsql/data/postgresql.conf
# /etc/init.d/postgresql start
# su - postgres
$ psql
# create database pgbench;
# \q

# pgbench -i pgbench && pgbench -c 10 -t 10000 pgbench
tps = 4670.635648 (including connections establishing)
tps = 4673.630345 (excluding connections establishing)[/code]

On kernel 3.5.3:
tps = ~5800

1) Host 1 - 15-20% performance drop
AMD Phenom(tm) II X6 1090T Processor
MB: AMD 880G
RAM: 16 Gb DDR3
SSD: PLEXTOR PX-256M3 256Gb

2) Host 2 - 15-20% performance drop
AMD Phenom(tm) II X6 1055T Processor
MB: AMD 990X
RAM: 32 Gb DDR3
SSD: Corsair Performance Pro 128Gb

3) Host 3 - no problems - same performance
Intel E6300
MB: Intel® P43 / ICH10
RAM: 4 Gb DDR3
HDD: SATA 7200 rpm

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.

--




--------------050201080608030008080201--