From: Mkrtchyan, Tigran <tigran.mkrtchyan@desy.de>
To: Josh Berkus <josh@agliodbs.com>
Cc: Andres Freund <andres@anarazel.de>
Cc: pgsql-performance <pgsql-performance@postgresql.org>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Subject: Re: 9.5alpha1 vs 9.4
Date: Mon, 6 Jul 2015 23:14:31 +0200 (CEST)
Message-ID: <bd8af33c-6683-433a-9526-dcd8e618ec32@email.android.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
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 with INSERT 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
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tigran.mkrtchyan@desy.de, josh@agliodbs.com, andres@anarazel.de, tgl@sss.pgh.pa.us
Subject: Re: 9.5alpha1 vs 9.4
In-Reply-To: <bd8af33c-6683-433a-9526-dcd8e618ec32@email.android.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox