From: Greg Smith <greg@2ndquadrant.com>
To: Eliot Gable <egable+pgsql-performance@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: GPU Accelerated Sorting
Date: Mon, 30 Aug 2010 10:05:21 -0400
Message-ID: <4C7BBAA1.6040808@2ndquadrant.com> (raw)
In-Reply-To: <AANLkTimjYxrvMGMLhh3q=82iNiKKjQvPRcrsgX7DHcMp@mail.gmail.com>
References: <AANLkTimjYxrvMGMLhh3q=82iNiKKjQvPRcrsgX7DHcMp@mail.gmail.com>
Eliot Gable wrote:
> Not sure if anyone else saw this, but it struck me as an interesting
> idea if it could be added to PostgreSQL. GPU accelerated database
> operations could be very... interesting. Of course, this could be
> difficult to do in a way that usefully increases performance of
> PostgreSQL, but I'll leave that up to you guys to figure out.
>
This comes up every year or so. The ability of GPU offloading to help
with sorting has to overcome the additional latency that comes from
copying everything over to it and then getting all the results back. If
you look at the typical types of sorting people see in PostgreSQL, it's
hard to find ones that are a) big enough to benefit from being offloaded
to the GPU like that, while also being b) not so bottlenecked on disk
I/O that speeding up the CPU part matters. And if you need to sort
something in that category, you probably just put an index on it instead
and call it a day.
If you made me make a list of things I'd think would be worthwhile to
spend effort improving in PostgreSQL, this would be on the research
list, but unlikely to even make my personal top 100 things that are work
fiddling with.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com www.2ndQuadrant.us
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: greg@2ndquadrant.com, egable+pgsql-performance@gmail.com
Subject: Re: GPU Accelerated Sorting
In-Reply-To: <4C7BBAA1.6040808@2ndquadrant.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox