2

I would like to start using the GPU on my server in my PostgreSQL queries. I cannot find much information about the use of PG-Strom for spatial queries. The most I have found is that it may be coming in PostgreSQL 9.6. We are beyond that now. So? What's happening with this? Where are the resources?

http://on-demand.gputechconf.com/gtc/2015/presentation/S5276-Kohei-KaiGai.pdf

https://github.com/heterodb/pg-strom

I am working with PostgreSQL 12.1, PostGIS 3 with a VOLTA Tesla V100 16GB

Vince
  • 20,017
  • 15
  • 45
  • 64
D_C
  • 1,359
  • 10
  • 23

1 Answers1

1

After being in contact with the developers of Pg-Strom, we are now aware that spatial queries are not currently supported by Pg-Strom, nor is there a plan to do so in the near future without financial investment.

"Right now, we have no special activities to support PostGIS functions, due to non-technical reasons. We have not met a prospective user who agree to purchase our enterprise software subscription with support of the spatial functions in the past, even though some folks are interested in the feature.

From the standpoint of technology, yes, here is no reason why we cannot implement GPU-executable version of these PostGIS functions...

If you can give us a commitment of the purchase and the target workloads (data & queries) to be accelerated in the 1st version, we can move forward the related features." --KaiGai Kohei

D_C
  • 1,359
  • 10
  • 23