Re: postgres 9.3 vs. 9.4

From: didier <did447(at)gmail(dot)com>
To: "Mkrtchyan, Tigran" <tigran(dot)mkrtchyan(at)desy(dot)de>
Cc: Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>, Merlin Moncure <mmoncure(at)gmail(dot)com>, postgres performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: postgres 9.3 vs. 9.4
Date: 2014-09-18 21:28:41
Message-ID: CAJRYxuJUkh1GmcNKTW2J8BdKU6GKoqoduTm=G7X-OVVWrBJfsQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, Sep 18, 2014 at 11:10 PM, Mkrtchyan, Tigran
<tigran(dot)mkrtchyan(at)desy(dot)de> wrote:
>
>
> ----- Original Message -----
>> From: "Mark Kirkwood" <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>
>> To: "Merlin Moncure" <mmoncure(at)gmail(dot)com>, "Tigran Mkrtchyan" <tigran(dot)mkrtchyan(at)desy(dot)de>
>> Cc: "postgres performance list" <pgsql-performance(at)postgresql(dot)org>
>> Sent: Thursday, September 18, 2014 10:56:36 PM
>> Subject: Re: [PERFORM] postgres 9.3 vs. 9.4
>>
>> On 19/09/14 08:32, Merlin Moncure wrote:
>> > On Thu, Sep 18, 2014 at 4:58 AM, Mkrtchyan, Tigran
>> > <tigran(dot)mkrtchyan(at)desy(dot)de> wrote:
>> >>
>> >> 9.3.5:
>> >> 0.035940 END;
>> >>
>> >>
>> >> 9.4beta2:
>> >> 0.957854 END;
>> >
>
> 10 minutes run had the same results.
>
> Is there some kind of statistics which can tell there time is spend?
> Or the only way is to run on solaris with dtrace? For me it's more important
> to find why I get only 1500tps with 9.3. The test with 9.4 was just a hope for
> a magic code change that will give me a better performance.

Can you test 9.3 on the 9.4 computer?

Regards

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jeff Janes 2014-09-18 21:34:26 Re: postgres 9.3 vs. 9.4
Previous Message Mkrtchyan, Tigran 2014-09-18 21:10:54 Re: postgres 9.3 vs. 9.4