News for hackers. Stuff that matters.
Re:Vitesse X – A PostgreSQL extension module for faster queries by mrmondo on Monday May 25, 2015 @07:29PM (#9602174)
This feels a little like 'snake oil' to me - a little short on real details and the idea of using licensed software especially with my database server does not sound like something that I want to go back to.
Re:Vitesse X – A PostgreSQL extension module for faster queries by quizotic on Monday May 25, 2015 @08:13PM (#9602288)
probably not snake oil; and 180x faster on tpch-1 is no where near physics speed. but these guys are just starting out. i'm sure they will go even faster once they pull out the stops.

the nice thing about their model is that it's a pure accelerator play. plug it in and go faster, pull it out, or replace it with something else. in theory, there should be no change to the application/query layer. It should be as simple as entering "create/drop extension vitessedata;"

Re:Vitesse X – A PostgreSQL extension module for faster queries by petergeoghegan on Monday May 25, 2015 @11:04PM (#9602750)
Sorting will be a lot faster on PostgreSQL 9.5:

http://pgeoghegan.blogspot.com/2015/01/abbreviated-keys-expl...

http://pgeoghegan.blogspot.com/2015/04/abbreviated-keys-for-...

I wonder whether and to what extent Vitesse benefits from using this technique, which is fairly well known (e.g. it appears in a 1994 paper by Gray -- Alphasort).

As I go into in the second link there, someone reported an order of magnitude increase in sort performance in one case.

For what it's worth, I doubt that this fully accounts for why Vitesse is faster. I don't know that I'd trust my data to it, but I don't think it's snake oil, even if some of the figures shown are arguably a bit misleading.

Re:Vitesse X – A PostgreSQL extension module for faster queries by ctan on Thursday May 28, 2015 @05:42PM (#9621366)
(ck from vitesse data) We haven't exploited this technique mentioned by Peter. We will when 9.5 comes out, and we are looking at it to see if we can put it into our 9.4 extension so people can benefit from it before 9.5. The technique is sound, which should make it go even faster as plans generated by Postgres seem to be partial towards sorts.

As for the trust element, yeah, we know it would take time to earn that in the market place.