4 ms·

There is also GPU support for PostgreSQL using an extension called pg-strom https://github.com/heterodb/pg-strom https://github.com/heterodb/pg-strom Not sure

There is also GPU support for PostgreSQL using an extension called pg-strom https://github.com/heterodb/pg-strom https://github.com/heterodb/pg-strom Not sure how it compares to this tool, but it uses a GPU to do both high density analytics, by loading data straight from disk to the gpu with dma avoiding the cpu entirely to do the work, or by using the GPU as a prefilter to remove lots of candidate rows and then letting the CPU do the core query on much fewer rows.

felipe_aramburu 8y ago
PG-Strom is a great way to make postgres faster. Nice. But if the purpose is here to build very fast and responsive system which is interacting with other gpu tools well then snap I don't see how it can compete. The old school way of, run this query, get my results, read those results using something like jdbc, is too slow. You can literally take out the "run this query" portion and it will still be slower than what we believe needs to exist to power GPU accelerated workloads. We are trying to keep up with the pace of hardware improvements that NVIDIA has been churning out. Moving a result set from Postgres ==> "wherever I need to be" by performing copies and making allocations for that data is a cost we want to save people from.