Kontinuation opened a new pull request, #26:
URL: https://github.com/apache/sedona-db/pull/26
This patch uses TG as the default library for evaluating spatial predicates.
TG has better overall performance compared to GEOS, but it does not always
produce the same result as GEOS. See the skipped python test for an example.
Here is the benchmark result of ST_Contains after switching to TG:
```
------------------------------------------------------------------------------------------
benchmark 'table=polygons_complex': 6 tests
-------------------------------------------------------------------------------------------
Name (time in ms) Min
Max Mean StdDev Median
IQR Outliers OPS Rounds Iterations
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
test_st_contains[polygons_complex-SedonaDB] 14,967.6217 (113.62)
15,101.0815 (112.21) 15,034.7782 (113.08) 58.7428 (44.96) 15,053.5245
(113.73) 103.6030 (44.66) 2;0 0.0665 (0.01) 5 1
test_st_contains[polygons_complex-PostGIS] 18,754.5553 (142.37)
18,947.6443 (140.79) 18,810.6307 (141.47) 77.8565 (59.60) 18,784.8336
(141.92) 60.9839 (26.29) 1;1 0.0532 (0.01) 5 1
test_st_contains[polygons_complex-DuckDB] 41,355.0608 (313.93)
41,757.0877 (310.27) 41,485.6860 (312.01) 158.4599 (121.29) 41,460.6061
(313.24) 152.4081 (65.69) 1;0 0.0241 (0.00) 5 1
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------
benchmark 'table=polygons_simple': 6 tests
----------------------------------------------------------------------------------------
Name (time in ms) Min
Max Mean StdDev Median
IQR Outliers OPS Rounds Iterations
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
test_st_contains[polygons_simple-SedonaDB] 51.7848 (4.95)
53.2945 (4.59) 52.0883 (4.88) 0.3806 (1.78) 51.9682 (4.89)
0.2382 (1.07) 2;2 19.1982 (0.21) 15 1
test_st_contains[polygons_simple-PostGIS] 503.0724 (48.12)
504.4988 (43.48) 503.9603 (47.18) 0.5745 (2.68) 504.0978 (47.39)
0.8316 (3.72) 1;0 1.9843 (0.02) 5 1
test_st_contains[polygons_simple-DuckDB] 1,028.6870 (98.39)
1,052.6184 (90.72) 1,038.6616 (97.23) 11.0858 (51.76) 1,032.6861
(97.09) 19.3825 (86.66) 1;0 0.9628 (0.01) 5 1
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
