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