Skip to main content

Table 1 Benchmark results for the two examined storage layouts

From: Efficient storage of heterogeneous geospatial data in spatial databases

 ImportQuery—intersectQuery—intersect/attributeDisk size
Speed (m)SDSpeed (s)SDSpeed (s)SD(GB)
Table-based793.57190.54993.2412.29
Jsonb1794.50251.001623.3017.50
Difference100 6 63 5.21
  1. The better results for each metric are emphasized