[DSC 4.0] Accelerating PostgreSQL Full Table Scan OLAP queries - N. Krgovic, A. Dragacevac
The talk focuses on different methods of improving performance of OLAP queries requiring full table scans, using various techniques:
Query parallelization using multiple PostgreSQL instances,
switching over to columnar based storage engine,
and using GPU acceleration for queries.
Other than providing an overview of these techniques with explanation, the talk will present concrete results and measurements, running queries against all these cases.
This talk was presented by Mr. Nikola Krgovic, Senior System Engineer at Twin Star Systems and Aleksandar Dragacevac, Team Lead Senior Data Engineer at Cube team, during Data Science Conference 4.0, as a part of Big Data track.
You can find this talk presentation on the following link:
https://www.slideshare.net/Insitute_o...
More info about Data Science Conference:
Website: http://datasciconference.com
Instagram: / datasciconf
Facebook: / datasciconference
Twitter: / datasciconf
Flickr: https://www.flickr.com/photos/data-sc...
To watch more new videos regarding Data Science - click subscribe to our YouTube Channel.
