Re: 9.5alpha1 vs 9.4 - Mailing list pgsql-performance

From Josh Berkus
Subject Re: 9.5alpha1 vs 9.4
Date
Msg-id 559AB0AD.1060509@agliodbs.com
Whole thread Raw
In response to 9.5alpha1 vs 9.4  ("Mkrtchyan, Tigran" <tigran.mkrtchyan@desy.de>)
List pgsql-performance
On 07/05/2015 10:16 AM, Mkrtchyan, Tigran wrote:
> Thanks for the hin. My bad. The backup db and 9.5 had a different type on
> one of the foreign-key constrains char(36) vs varchar(36).
>
> The schema was screwed couple of days ago, byt performance numbers I checked only
> after migration to 9.5.

Thank you for testing!

Can you re-run your tests with the fixed schema?  How does it look?

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com


pgsql-performance by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Hmmm... why does pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
Next
From: Steve Crawford
Date:
Subject: Re: New server: SSD/RAID recommendations?