From: Mkrtchyan, Tigran <tigran.mkrtchyan@desy.de>
To: Merlin Moncure <mmoncure@gmail.com>
Cc: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
Cc: postgres performance list <pgsql-performance@postgresql.org>
Subject: Re: postgres 9.3 vs. 9.4
Date: Wed, 24 Sep 2014 11:23:48 +0200 (CEST)
Message-ID: <1160757821.126570.1411550628851.JavaMail.zimbra@desy.de> (raw)
In-Reply-To: <CAHyXU0yOfJ1mj2W0mBd==-hO260g8vtC7=-ptORnR2pfymShyA@mail.gmail.com>
References: <45142416.42827.1411033201079.JavaMail.zimbra@desy.de>
<753223953.46319.1411106018106.JavaMail.zimbra@desy.de>
<541BCC93.9070204@catalyst.net.nz>
<212134052.46894.1411111441514.JavaMail.zimbra@desy.de>
<541CC338.5090700@catalyst.net.nz>
<CAHyXU0zj8P41G-5QpL2Lz-DYLtfsqQP3TbR3pLTFhUUuYg8ekQ@mail.gmail.com>
<1234976322.60875.1411477085811.JavaMail.zimbra@desy.de>
<CAHyXU0yOfJ1mj2W0mBd==-hO260g8vtC7=-ptORnR2pfymShyA@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
Hi Merlin et al.
after building postgres 9.4 myself from sources I get the same performance as
with 9.3. The difference was in the value of debug_assertions setting.
Now the next step. Why my 3 years old laptop gets x1.8 times more tps than my one month old server?
And Mark Kirkwood's desktop gets x2 times more tps as well? Is there some special optimization
for i7 which does not work with Intel(R) Xeon(R) CPU E5-2660?
Thanks,
Tigran.
----- Original Message -----
> From: "Merlin Moncure" <mmoncure@gmail.com>
> To: "Tigran Mkrtchyan" <tigran.mkrtchyan@desy.de>
> Cc: "Mark Kirkwood" <mark.kirkwood@catalyst.net.nz>, "postgres performance list" <pgsql-performance@postgresql.org>
> Sent: Tuesday, September 23, 2014 4:21:13 PM
> Subject: Re: [PERFORM] postgres 9.3 vs. 9.4
>
> On Tue, Sep 23, 2014 at 7:58 AM, Mkrtchyan, Tigran
> <tigran.mkrtchyan@desy.de> wrote:
> > Hi Merlin,
> >
> > you are right, in 9.4 the debug_assertions are on:
> >
> > # /etc/init.d/postgresql-9.4 start
> > Starting postgresql-9.4 service: [ OK ]
> > # psql -U postgres
> > psql (9.4beta2)
> > Type "help" for help.
> >
> > postgres=# select name,setting from pg_settings where
> > name='debug_assertions';
> > name | setting
> > ------------------+---------
> > debug_assertions | on
> > (1 row)
>
>
> (plz try to not top-post).
>
> That's not not really unexpected: 9.4 is still in beta. If you're
> just doing raw performance testing consider building a postgres
> instance from source (but, instead of compiling into /usr/local/bin,
> I'd keep it all in private user folder for easy removal).
>
> For example, if I downloaded the source into /home/mmoncure/pgdev/src,
> i'd approximately do:
>
> cd /home/mmoncure/pgdev/src
> ./configure --prefix=/home/mmoncure/pgdev
> # if configure gripes about missing readline, go grab the
> libreadline-dev rpm etc and repeat above
> make -j4 && make install
> export PATH=/home/mmoncure/pgdev/bin:$PATH
> export PGDATA=/home/mmoncure/pgdev/data
> # use C locale. may not be appropriate in your case
> initdb --no-locale --encoding=UTF8
> pg_ctl start
>
> This should suffice any beta performance testing you need to do. When
> 9.4 proper comes out, just stop the database and kill the pgdev folder
> (taking a backup first if you need to preserve stuff).
>
> merlin
>
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
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: tigran.mkrtchyan@desy.de, mmoncure@gmail.com, mark.kirkwood@catalyst.net.nz
Subject: Re: postgres 9.3 vs. 9.4
In-Reply-To: <1160757821.126570.1411550628851.JavaMail.zimbra@desy.de>
* 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