[JP]OSS版PG-StromでのPostGISの&&演算子サポート有無について

[kzyoshimura]

いくつかのPostGISでのSQL実行において、&&演算子を利用するとGPU利用されませんでした。※&&演算子なしの結果よりも、&&演算子利用しCPU処理される方が速い結果となりました
OSS版PG-StromではPostGISの&&演算子のサポート予定はありますでしょうか？
【実行環境】
PG-Strom：v6.0
cuda：12.8.1

【実行したSQL】
①st_crosses
EXPLAIN ANALYZE SELECT m.geom FROM mesh6 m INNER JOIN youto y ON st_crosses(m.geom, y.wkb_geometry) ;
実行結果

                                                                         QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------------
 Gather  (cost=28029.86..193571732.96 rows=1715987392 width=120) (actual time=222876.920..222902.543 rows=0 loops=1)
   Workers Planned: 2
   Workers Launched: 2
   ->  Parallel Custom Scan (GpuJoin) on mesh6 m  (cost=27029.86..21971993.76 rows=714994747 width=120) (actual time=219603.182..219603.210 rows=0 loops=3)
         GPU Projection: geom
         GPU Join Quals [1]: st_crosses(geom, wkb_geometry) [plan: 10355260 -> 714994700, exec: 24853312 -> 0]
         GPU GiST Join [1]: (wkb_geometry && geom) on youto_wkb_geometry_geom_idx (wkb_geometry) [fetched: 5735003]
         GpuJoin buffer usage: 422.20MB
         Scan-Engine: VFS with GPU0; vfs=507211, ntuples=24853312
         ->  Parallel Seq Scan on youto y  (cost=0.00..25496.62 rows=43262 width=2063) (actual time=0.040..83.824 rows=34610 loops=3)
 Planning Time: 5.990 ms
 Execution Time: 222910.324 ms
(12 rows)

②st_crosses　&&演算子あり
EXPLAIN ANALYZE SELECT m.geom FROM mesh6 m INNER JOIN youto y ON m.geom && y.wkb_geometry AND st_crosses(m.geom, y.wkb_geometry) ;
実行結果

                                                                   QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------------
 Gather  (cost=1000.42..983540.42 rows=1141125 width=120) (actual time=7845.840..7901.223 rows=0 loops=1)
   Workers Planned: 2
   Workers Launched: 2
   ->  Nested Loop  (cost=0.42..868427.92 rows=475469 width=120) (actual time=7792.211..7792.212 rows=0 loops=3)
         ->  Parallel Seq Scan on youto y  (cost=0.00..25496.62 rows=43262 width=2063) (actual time=0.014..37.740 rows=34610 loops=3)
         ->  Index Scan using mesh6_geom_geom_idx on mesh6 m  (cost=0.42..19.47 rows=1 width=120) (actual time=0.222..0.222 rows=0 loops=103830)
               Index Cond: ((geom && y.wkb_geometry) AND (geom && y.wkb_geometry))
               Filter: st_crosses(geom, y.wkb_geometry)
               Rows Removed by Filter: 55
 Planning Time: 4.609 ms
 Execution Time: 7901.277 ms
(11 rows)

③st_contains
EXPLAIN ANALYZE SELECT m.geom FROM mesh6 m INNER JOIN youto y ON st_contains(m.geom, y.wkb_geometry) ;
実行結果

                                                                       QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------------
 Gather  (cost=28029.86..193571732.96 rows=1715987392 width=120) (actual time=2494.432..2494.540 rows=0 loops=1)
   Workers Planned: 2
   Workers Launched: 2
   ->  Parallel Custom Scan (GpuJoin) on mesh6 m  (cost=27029.86..21971993.76 rows=714994747 width=120) (actual time=2348.507..2348.517 rows=0 loops=3)
         GPU Projection: geom
         GPU Join Quals [1]: st_contains(geom, wkb_geometry) [plan: 10355260 -> 714994700, exec: 24853312 -> 0]
         GPU GiST Join [1]: (wkb_geometry @ geom) on youto_wkb_geometry_geom_idx (wkb_geometry) [fetched: 0]
         GpuJoin buffer usage: 422.20MB
         Scan-Engine: VFS with GPU0; vfs=507211, ntuples=24853312
         ->  Parallel Seq Scan on youto y  (cost=0.00..25496.62 rows=43262 width=2063) (actual time=0.027..47.106 rows=34610 loops=3)
 Planning Time: 9.794 ms
 Execution Time: 2507.836 ms
(12 rows)

④st_contains　&&演算子あり
EXPLAIN ANALYZE SELECT m.geom FROM mesh6 m INNER JOIN youto y ON m.geom && y.wkb_geometry AND st_contains(m.geom, y.wkb_geometry) ;
実行結果

                                                                   QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------------
 Gather  (cost=1000.42..983540.42 rows=1141125 width=120) (actual time=4.246..1936.974 rows=1558 loops=1)
   Workers Planned: 2
   Workers Launched: 2
   ->  Nested Loop  (cost=0.42..868427.92 rows=475469 width=120) (actual time=2.703..1873.992 rows=519 loops=3)
         ->  Parallel Seq Scan on youto y  (cost=0.00..25496.62 rows=43262 width=2063) (actual time=0.019..42.005 rows=34610 loops=3)
         ->  Index Scan using mesh6_geom_geom_idx on mesh6 m  (cost=0.42..19.47 rows=1 width=120) (actual time=0.050..0.051 rows=0 loops=103830)
               Index Cond: ((geom && y.wkb_geometry) AND (geom ~ y.wkb_geometry))
               Filter: st_contains(geom, y.wkb_geometry)
               Rows Removed by Filter: 0
 Planning Time: 4.528 ms
 Execution Time: 1937.309 ms