admin管理员组文章数量:1613376
文章目录
- canci
- these systems
- perform orders of magnitude
- better than
- CPU-based database systems on analytical workloads
- Hardware expert
- suspicion
- database operators a
- memory-bandwidth bound
再一次体现了数据库操作是带宽受限的这个认识!
- one would expect
- the maximum gain to be roughly
- equal to the ratio of the memory bandwidth of GPU to that of CPU
你能获得的最大的加速比应该就是GPU和CPU的带宽比吧!
- adopt a model-based approach to
- understand when and why the performance gains of running queries on GPUs vs on CPUs vary from the bandwidth ratio (which is roughly 16x on modern hardware).
- Crystal
- a library of parallel routines
- that can be combined together
- to run full SQL queries on a GPU with minimal materialization overhead.
- We implement individual query operators to
- show that
- while the speedups for selection, projection, and sorts are near the bandwidth ratio,
- joins achieve less speedup due to differences in hardware capabilities
- a popular analytical workload
- full query performance gain from running on GPU
- exceeds the bandwidth ratio
- despite individual operators having speedup less than bandwidth ratio,
- as a result of
- limitations of vectorizing chained operators on CPUs,
- resulting in a 25x speedup for GPUs over CPUs on the benchmark
canci
- 添加链接描述
本文标签: fundamentalPerformanceStudyCharacteristicsDatabase
版权声明:本文标题:2020:Study of the Fundamental Performance Characteristics of GPUs and CPUs for Database Analytics 内容由热心网友自发贡献,该文观点仅代表作者本人, 转载请联系作者并注明出处:https://m.elefans.com/xitong/1728643168a1167371.html, 本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容,一经查实,本站将立刻删除。
发表评论