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 ).
Depending on the amount of data it has to query it absolutely can take forever.