3
45%
master: 45%

Ran 26 Aug 2019 11:09PM UTC

Files 101

Run time 9s

Badge

Embed ▾

Committed 26 Aug 2019 05:29PM UTC coverage: 41.442% (-0.007%) from 41.449%

Job # 6279.3

Build Type

push

travis-ci

Committed by

tomka

Commit Message

Add parent ID to treenode_edge table

This can improve spatial query time significantly, because it allows us
to avoid the JOIN that found the parent nodes before.

The application of migration 82 might take a while to complete, because it
rewrites a potentially big table (treenode_edge). Therefore, make also sure
that there is enough space available at the database storage location (25% of
database data directory should be plenty). If no replication is used, setting
the following Postgres options can speed up the process by allowing
Postgres to skip the WAL for the migration: `wal_level = minimal`,
`archive_mode = off` and `max_wal_senders = 0`.

The table is completely recreated from scratch, because it had to be
rewritten anyway and doing so ourselves through a separate table allows
us to reclaim space more quickly and without VACUUM FULL. Indices had to
be rewritten, too, in most cases. Reindexing and constraint checking is
therefore done in bulk after the new table is created, which speeds up
the process as well.

The column alignment is optimal, and eight bytes more are now used per
tuple (one extra bigint), which makes it 105 in total.

Run Details

7542 of 18199 relevant lines covered (41.44%)

0.41 hits per line

catmaid / CATMAID / 6279 / 3
45%
master: 45%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Source Files on job 6279.3

catmaid / CATMAID / 6279 / 3 45% master: 45%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Source Files on job 6279.3

catmaid / CATMAID / 6279 / 3
45%
master: 45%

README BADGES
x