News for hackers. Stuff that matters.
Re:Vitesse X – A PostgreSQL extension module for faster queries by aw3c2 on Monday May 25, 2015 @04:26PM (#9601591)
I am a happy postgres user for years, nothing special, just for personal projects. This site tells me so few things and sounds so flawless, that I am not sure if it is a parody or actually a product. Why would some random software be able to make my pg 8 times faster or more?
Re:Vitesse X – A PostgreSQL extension module for faster queries by nierman on Monday May 25, 2015 @05:19PM (#9601799)
Check out the Tech and Company pages as well as the slides from the recent South Bay PostgreSQL Meeetup: http://goo.gl/Mtg2W6

The founders both have strong academic and commercial experience and the advisor is Prof. Joseph Hellerstein (he has both an excellent academic reputation and good experience in industry/tech transfer).

Note that TPCH is a "decision support benchmark". There are other technologies for helping postgres with these workloads as well: a column-store approach like https://github.com/citusdata/cstore_fdw, or the recent work on parallel sequential scans in Postgres core (http://rhaas.blogspot.com/2015/03/parallel-sequential-scan-f...), etc.

Re:Vitesse X – A PostgreSQL extension module for faster queries by saurik on Monday May 25, 2015 @05:06PM (#9601756)
Did you bother to click on any of the links, or did you just glance at the "news" page? Almost half of the links on the page ("technology", "check it out", "100% Postgres, 100X Faster for Analytics", or "(slides)") they explain how it works (and it makes sense, although I'd personally be very wary of installing this, due to not particularly trusting that it gets the implementation "correct").
Re:Vitesse X – A PostgreSQL extension module for faster queries by aw3c2 on Tuesday May 26, 2015 @04:35AM (#9603528)
I did read the Technology page but it sounded so much like buzzword bingo that I really was not sure. Thanks!
Re:Vitesse X – A PostgreSQL extension module for faster queries by halayli on Monday May 25, 2015 @05:14PM (#9601778)
You might need to update your about section on HN:

> "In an attempt to avoid losing my entire life to this website, I no longer comment as often as I used to, and, when I do, unless it is related to a topic (iOS jailbreaking) where it is part of my "job" to respond, I make it something of a policy to not look at things people say in response until at least a month later."

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.

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.
Re:Vitesse X – A PostgreSQL extension module for faster queries by quizotic on Tuesday May 26, 2015 @06:38PM (#9608143)
> Why would some random software be able to make my pg 8 times faster or more?

Peter Boncz (creator of VectorWise, HyPer) says it best here: http://www.tpc.org/tpctc/tpctc2013/slides_and_papers/005.pdf

Remember also that the postgres planner and execution machinery is ANCIENT. Plan scoring still assumes Disk I/O = 10 MemoryAccess = 100CPU instructions. Modern CPUs are SIMD and Vector processing, but PG planning/exec machinery isn't vector aware. There's a 200X difference between L1 cache and main memory access that the PG planner can't see. And what about SSDs and NVMe vs disk? Spark gains its speed through caching intermediate result sets along with the ability to reconstruct them. But postgres doesn't cache intermediate results or query plans last I checked. Plus a million other things.

Postgres is wonderful, but not because it has natively fast analytics. 8X is nothing. 180X is better, but not as fast as Vertica, Aster, Greenplum, et al. I say kudos to Citus and Vitesse for leading the way.

Re:Vitesse X – A PostgreSQL extension module for faster queries by cbsmith on Tuesday May 26, 2015 @03:41AM (#9603390)
> Why would some random software be able to make my pg 8 times faster or more?

I think we've already seen plenty of evidence that for OLAP type queries, there is a TON of room available for improvement vs. off the shelf PostgreSQL.