Month: September 2015
Scaling PostgreSQL: Using more than just one core for aggregation
Scaling PostgreSQL: Modern servers provide people with more and more CPU cores. 16 cores or more are not uncommon these days. Unfortunately, PostgreSQL cannot scale a single query to more than one core. A lot of effort is going into this issue already. CYBERTEC experiments To address the issue, we’ve done some experiments to see […]
pgstrom: PostgreSQL on a GPU with joins
In my previous post I have shared some GPU performance data, which were mostly related to aggregation. Given the information I have found on the pgstrom wiki page, I decided to give joins a try to see how much speed we can gain by offloading some of the work PostgreSQL has to do to the […]
pgstrom: Checking GPU performance
Finally I got around to take a more extensive look at pgstrom (a module to make use of GPUs). The entire GPU thing fascinates me, and I was excited to see the first real performance data. Here is some simple test data: 5 million rows should be enough to get a first impression of what […]
Testing GPU-accelerated PostgreSQL
NVIDIA’s CUDA is definitely a great thing and I have to admit that I already got excited years ago when I first learned about it. For many operations a nicely optimized GPU implementation definitely seems the way to go. GPUs are traditionally used for scientific operations and massively parallel tasks. However, some important work is […]