News for hackers. Stuff that matters.

A comment on Vitesse X – A PostgreSQL extension module for faster queries. Parent comment

Re:Vitesse X – A PostgreSQL extension module for faster queries by electrum on Tuesday May 26, 2015 @01:39AM (#9603112)
The 8x improvement is somewhat misleading as it is based on a single TPC-H query. The other queries from the benchmark seem to show a ~3x improvement: http://vitessedata.com/technology

Given that their query engine uses an LLVM JIT compared to the standard PostgreSQL interpreter, these results are very reasonable. This is similar to comparing an interpreter vs a JIT for a programming language.

Even with the best intentions, benchmarking a database is notoriously difficult. I work on Presto, a distributed analytic SQL database, and we are often asked how it compares to other systems, or how it will perform for a given workload. The answer is always "try it and see", both because how it performs for your configuration and workload is the only thing that matters, and because there are so many variables that factor into the result.

[ Parent | on HN ]
Re:Vitesse X – A PostgreSQL extension module for faster queries by ctan on Thursday May 28, 2015 @05:50PM (#9621403)
Yes, the technology page calls out that on average it is 3.7X faster with just LLVM and algorithmic improvements. We are trying to push more value into Vitesse X by adding vector processing, and maybe include some of our threading work in the next version.
[ Parent | on HN ]