admin管理员组

文章数量:1613401

文章目录

    • 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

  • 添加链接描述
  • pdf

本文标签: fundamentalPerformanceStudyCharacteristicsDatabase