Re: CUDA Sorting - Mailing list pgsql-hackers

From Florian Pflug
Subject Re: CUDA Sorting
Date
Msg-id 8A0DE4CF-DE2B-4D11-99F3-405F70A31785@phlo.org
Whole thread Raw
In response to Re: CUDA Sorting  (Stephen Frost <sfrost@snowman.net>)
List pgsql-hackers
On Sep19, 2011, at 19:46 , Stephen Frost wrote:
> I agree that it'd be interesting to do, but I share Lord Stark's
> feelings about the challenges and lack of potential gain- it's a very
> small set of queries that would benefit from this.  You need to be
> working with enough data to make the cost of tranferring it all over to
> the GPU worthwhile, just for starters..

I wonder if anyone has ever tried to employ a GPU for more low-level
tasks. Things like sorting or hashing are hard to move to the
GPU in postgres because, in the general case, they involve essentially
arbitrary user-defined functions. But couldn't for example the WAL CRC
computation be moved to a GPU? Or, to get really crazy, even the search
for the optimal join order (only for a large number of joins though,
i.e. where we currently switch to a genetic algorithmn)?

best regards,
Florian Pflug



pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Separating bgwriter and checkpointer
Next
From: Shigeru Hanada
Date:
Subject: Re: WIP: Collecting statistics on CSV file data