From: Efficient storage of heterogeneous geospatial data in spatial databases
Import | Query—intersect | Query—intersect/attribute | Disk size | ||||
---|---|---|---|---|---|---|---|
Speed (m) | SD | Speed (s) | SD | Speed (s) | SD | (GB) | |
Table-based | 79 | 3.57 | 19 | 0.54 | 99 | 3.24 | 12.29 |
Jsonb | 179 | 4.50 | 25 | 1.00 | 162 | 3.30 | 17.50 |
Difference | 100 | 6 | 63 | 5.21 |