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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
