2954
47%
master: 45%

Ran 21 Jan 2017 02:49AM UTC

Jobs 1

Files 85

Run time 4s

Badge

Embed ▾

pending completion

Build # 2954

Build Type

push

travis-ci

Committed by

tomka

Commit Message

Improve performance of spatial queries

For each of the following tables two new indices are created:
treenode_edge, treenode_connector_edge and connector_geom. The fist
index is a Z min/max range index, which makes it fast to filter on Z
ranges. This is an expression index, so no actual min/max computations
have to be made. The second index is a 2D GIST index, which allows for
fast XY bounding box queries. Thanks to @Remi-Ci's help on the PostGIS
mailing list, I now know that both work very well together.

This makes node queries more than a magnitude faster: A test query
with 6799 treenodes went down from 600ms to 34ms and query returning 309
connectors went down from 50ms to 4ms. The returned query results are
exactly the same.

So far I didn't test insertion performance, but I don't think this will
be big problem. The ND index is also still required for the
ST_3DWithin() false positive removal. But as soon this is replaced, we
shouldn't need the ND index anymore (which could help insertion
performance, if it really would be a problem).

This update also improves access to orthogonal fields of view by about
the same amount.

Run Details

5942 of 12541 relevant lines covered (47.38%)

0.47 hits per line

Jobs

ID	Job ID	Ran	Files	Coverage
1	2954.1	21 Jan 2017 02:49AM UTC	0	47.38	Travis Job 2954.1

Source Files on build 2954

Detailed source file information is not available for this build.

catmaid / CATMAID / 2954
47%
master: 45%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 2954

catmaid / CATMAID / 2954 47% master: 45%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 2954

catmaid / CATMAID / 2954
47%
master: 45%

README BADGES
x