News for hackers. Stuff that matters.
Re:SQL on Distributed GPUs now available on AWS Marketplace by obstinate on Wednesday March 29, 2017 @02:44PM (#13989308)
I suppose it depends on what operations you do on your table and what your query stream looks like. It's hard to imagine compute being the bottleneck for most SQL workloads . . .
Re:SQL on Distributed GPUs now available on AWS Marketplace by threeseed on Wednesday March 29, 2017 @06:23PM (#13991187)
SQL is an overloaded term these days.

There are plenty of SQL queries happening on non-database platforms e.g. Spark, Impala all of which are entirely CPU bound.

Re:SQL on Distributed GPUs now available on AWS Marketplace by qeternity on Wednesday March 29, 2017 @03:31PM (#13989774)
For OLAP use cases, CPU is most often a bottleneck...
Re:SQL on Distributed GPUs now available on AWS Marketplace by user5994461 on Wednesday March 29, 2017 @05:43PM (#13990873)
Doesn't OLAP implies branching/conditions? GPUs are terrible at evaluating if.
Re:SQL on Distributed GPUs now available on AWS Marketplace by arnon on Wednesday March 29, 2017 @05:53PM (#13990958)
OLAP is implied as a catch-all for analytics in this case
Re:SQL on Distributed GPUs now available on AWS Marketplace by Wheaties466 on Wednesday March 29, 2017 @03:11PM (#13989592)
On a Postgresql query before version 9.6 is limited to a single CPU core.

Depending on the amount of data it has to query it absolutely can take forever.

Re:SQL on Distributed GPUs now available on AWS Marketplace by user5994461 on Wednesday March 29, 2017 @05:44PM (#13990886)
Consider a paid database if that's what you need. It's not new that postgre has some limitations compared to the SQL servers/Oracle.
Re:SQL on Distributed GPUs now available on AWS Marketplace by qeternity on Wednesday March 29, 2017 @03:32PM (#13989779)
Even now, it's only multicore when doing full table scans (iirc...)
Re:SQL on Distributed GPUs now available on AWS Marketplace by jasonmp85 on Wednesday March 29, 2017 @05:01PM (#13990558)
True (see here: https://www.postgresql.org/docs/9.6/static/parallel-plans.ht... ), but in PostgreSQL 10 there are Parallel Bitmap Heap Scans and Parallel Index Scans (see here: http://rhaas.blogspot.com/2017/03/parallel-query-v2.html ).