3 ms·

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 t

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;"

petergeoghegan 11y ago
Sorting will be a lot faster on PostgreSQL 9.5: http://pgeoghegan.blogspot.com/2015/01/abbreviated-keys-exploiting-locality-to.html http://pgeoghegan.blogspot.com/2015/01/abbreviated-keys-expl... http://pgeoghegan.blogspot.com/2015/04/abbreviated-keys-for-numeric-to.html 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.
- ctan 11y ago
  (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.

3 ms·

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 t

by quizotic 11y ago

petergeoghegan 11y ago
Sorting will be a lot faster on PostgreSQL 9.5: http://pgeoghegan.blogspot.com/2015/01/abbreviated-keys-exploiting-locality-to.html http://pgeoghegan.blogspot.com/2015/01/abbreviated-keys-expl... http://pgeoghegan.blogspot.com/2015/04/abbreviated-keys-for-numeric-to.html 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.
- ctan 11y ago
  (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.