1. Make the most out of your SIMD investments: counter control flow divergence in compiled query pipelines
- Author
-
Peter Boncz, Alfons Kemper, Thomas Neumann, Harald Lang, Andreas Kipf, Linnea Passing, and Centrum Wiskunde & Informatica, Amsterdam (CWI), The Netherlands
- Subjects
Geospatial analysis ,Computer science ,02 engineering and technology ,Parallel computing ,computer.software_genre ,SIMD ,Control flow ,020204 information systems ,AVX-512 ,Vectorization ,0202 electrical engineering, electronic engineering, information engineering ,Architecture ,Divergence (statistics) ,Efficient algorithm ,Query compilation ,05 social sciences ,InformationSystems_DATABASEMANAGEMENT ,ddc ,Full table scan ,Pipeline transport ,Query execution ,Database systems ,Hardware and Architecture ,Vectorization (mathematics) ,Control flow divergence ,020201 artificial intelligence & image processing ,0509 other social sciences ,Tuple ,050904 information & library sciences ,computer ,Information Systems - Abstract
Increasing single instruction multiple data (SIMD) capabilities in modern hardware allows for the compilation of data-parallel query pipelines. This means GPU-alike challenges arise: control flow divergence causes the underutilization of vector-processing units. In this paper, we present efficient algorithms for the AVX-512 architecture to address this issue. These algorithms allow for the fine-grained assignment of new tuples to idle SIMD lanes. Furthermore, we present strategies for their integration with compiled query pipelines so that tuples are never evicted from registers. We evaluate our approach with three query types: (i) a table scan query based on TPC-H Query 1, that performs up to 34% faster when addressing underutilization, (ii) a hashjoin query, where we observe up to 25% higher performance, and (iii) an approximate geospatial join query, which shows performance improvements of up to 30%.
- Published
- 2019
- Full Text
- View/download PDF