568
95%
master: 92%

Ran 24 Jan 2017 05:16PM UTC

Jobs 17

Files 73

Run time 12min

Badge

Embed ▾

pending completion

Build # 568

Build Type

push

travis-ci

Committed by

jamadden

Commit Message

postgres 9.5+ use ON CONFLICT UPDATE for store_temp

This cuts out a DELETE statement for every object stored. On benchmarks
this is a 15-20% win compared to the last commit:

BEFORE

"Transaction",                postgresql
"Add 1000 Objects",                18042
"Update 1000 Objects",             19380

AFTER

"Transaction",                postgresql
"Add 1000 Objects",                20705
"Update 1000 Objects",             23568

Run Details

10 of 10 new or added lines in 3 files covered. (100.0%)

4827 of 5370 relevant lines covered (89.89%)

10.27 hits per line

New Missed Lines in Diff

Lines	Coverage	∆	File
3	100.0		relstorage/adapters/postgresql/mover.py

Uncovered Existing Lines

Lines	Coverage	∆	File
1	100.0		relstorage/adapters/mover.py

Jobs

ID	Job ID	Ran	Coverage
1	568.1 (ENV=mysql)	24 Jan 2017 05:19PM UTC	85.68	Travis Job 568.1
2	568.2 (ENV=postgres)	24 Jan 2017 05:16PM UTC	56.67	Travis Job 568.2
3	568.3 (ENV=pypostgres)	24 Jan 2017 05:16PM UTC	57.19	Travis Job 568.3
4	568.4 (ENV=pymysql)	24 Jan 2017 05:19PM UTC	85.51	Travis Job 568.4
5	568.5 (ENV=umysqldb)	24 Jan 2017 05:20PM UTC	85.51	Travis Job 568.5
6	568.6 (ENV=mysql)	24 Jan 2017 05:20PM UTC		Travis Job 568.6
7	568.7 (ENV=postgres)	24 Jan 2017 05:18PM UTC		Travis Job 568.7
8	568.8 (ENV=pypostgres)	24 Jan 2017 05:20PM UTC		Travis Job 568.8
9	568.9 (ENV=mysql)	24 Jan 2017 05:24PM UTC	85.68	Travis Job 568.9
10	568.10 (ENV=postgres)	24 Jan 2017 05:22PM UTC	56.65	Travis Job 568.10
11	568.11 (ENV=pypostgres)	24 Jan 2017 05:22PM UTC	57.15	Travis Job 568.11
12	568.12 (ENV=pymysql)	24 Jan 2017 05:25PM UTC	85.47	Travis Job 568.12
13	568.13 (ENV=umysqldb)	24 Jan 2017 05:26PM UTC	86.24	Travis Job 568.13
14	568.14 (ENV=mysql)	24 Jan 2017 05:27PM UTC	85.72	Travis Job 568.14
15	568.15 (ENV=postgres)	24 Jan 2017 05:24PM UTC	56.67	Travis Job 568.15
16	568.16 (ENV=pypostgres)	24 Jan 2017 05:25PM UTC	57.19	Travis Job 568.16
17	568.17 (ENV=pymysql)	24 Jan 2017 05:29PM UTC	85.47	Travis Job 568.17

Source Files on build 568

Detailed source file information is not available for this build.

zodb / relstorage / 568
95%
master: 92%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

New Missed Lines in Diff

Uncovered Existing Lines

Jobs

Source Files on build 568

zodb / relstorage / 568 95% master: 92%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

New Missed Lines in Diff

Uncovered Existing Lines

Jobs

Source Files on build 568

zodb / relstorage / 568
95%
master: 92%

README BADGES
x