Does citus support geometric join between two distribution tables?

citusdata / citus

Distributed PostgreSQL as an extension

https://www.citusdata.com

GNU Affero General Public License v3.0

10.6k stars 671 forks source link

Does citus support geometric join between two distribution tables? #7685

Open sylph001 opened 2 months ago

sylph001 commented 2 months ago

Hi, Does the latest Citus support the spatial join operators that are provided from PostGis? This is because it seems the Citus documents shows that it fully supports what PostGis offers. For example, can we use ST_TOUCHES and ST_CROSSES for distributed tables?

Thanks

wildneuro commented 2 months ago

any updates?

emelsimsek commented 1 month ago

@sylph001, can you paste your scenario so that we can try it out?