Re: 9.5alpha1 vs 9.4
| От | Mkrtchyan, Tigran |
|---|---|
| Тема | Re: 9.5alpha1 vs 9.4 |
| Дата | |
| Msg-id | bd8af33c-6683-433a-9526-dcd8e618ec32@email.android.com обсуждение исходный текст |
| Ответ на | 9.5alpha1 vs 9.4 ("Mkrtchyan, Tigran" <tigran.mkrtchyan@desy.de>) |
| Список | pgsql-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 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
В списке pgsql-performance по дате отправления: