News for hackers. Stuff that matters.
Re:PGStrom: GPU-accelerated PostgreSQL by javajosh on Tuesday September 01, 2015 @11:32AM (#10153036)
Anyone have a sense for the kinds of queries this would actually help with?
Re:PGStrom: GPU-accelerated PostgreSQL by pcwalton on Tuesday September 01, 2015 @12:15PM (#10153459)
Probably queries that have a lot of brute-force comparisons involving full table scans. "select foo from bar where baz > 30" with no index, for example.

(Source: I've done a fair bit of experimentation in GPU queries in the domain of CSS selector matching.)

Re:PGStrom: GPU-accelerated PostgreSQL by radiowave on Tuesday September 01, 2015 @02:53PM (#10154816)
Interesting thought. I was assuming that the impressive performance figures based on joining 10 tables together would be making use of indexes, because with full table scans it might be difficult to keep the GPUs fed with data.
Re:PGStrom: GPU-accelerated PostgreSQL by jessedhillon on Tuesday September 01, 2015 @04:41PM (#10155535)
In the article linked, they show a multi-way join on integer keys, which is able to leverage accelerated integer comparison (presumably.) I'd imagine a whole range of GIS queries also have the potential to be sped up by GPU offloading.