6279
45%
master: 45%

Ran 26 Aug 2019 10:51PM UTC

Jobs 3

Files 101

Run time 18min

Badge

Embed ▾

pending completion

Build # 6279

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

8277 of 18582 relevant lines covered (44.54%)

1.24 hits per line

Jobs

ID	Job ID	Ran	Coverage
1	6279.1	26 Aug 2019 10:51PM UTC	44.54	Travis Job 6279.1
2	6279.2	26 Aug 2019 10:51PM UTC	44.54	Travis Job 6279.2
3	6279.3	26 Aug 2019 11:09PM UTC	41.44	Travis Job 6279.3

Source Files on build 6279

Detailed source file information is not available for this build.

catmaid / CATMAID / 6279
45%
master: 45%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 6279

catmaid / CATMAID / 6279 45% master: 45%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 6279

catmaid / CATMAID / 6279
45%
master: 45%

README BADGES
x