Re: postgres 9.3 vs. 9.4 - Mailing list pgsql-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
>