On Jul 6, 2015 18:45, Josh Berkus <josh@agliodbs.com> wrote:
>
> 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?
With fixed schema performance equal to 9.4. I have updated my code to use ON CONFLICT statement. ~5% better compared
withINSERT WHERE NOT EXIST. Really cool! Thanks.
Tigran.
>
> --
> 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