On Sun, May 29, 2016 at 2:43 PM, Stefan Keller <sfkeller@gmail.com> wrote:
Hi,
Nice work from you postgrespro.ru guys! Especially the RUM index which demonstrates the power of 9.6 to let third party SW create access methods as extension: https://github.com/postgrespro/rum
1. I don't understand the benchmarks on slide 25 "20 mln descriptions" (and the one before "6.7 mln classifieds"): What does "Queries in 8 h 9.2 +patch (9.6 rum)" mean?
We run queries for 8 hours and recorded the number of executed queries. Four years ago, when I and Alexander developed an initial version of patch we got results marked by "9.2+patch", and now we run the same queries on the same database and put rum results into (). I'd not consider to this numbers, since we used queries from 6 mln database. We'd be happy if somebody run independent benchmarks.
2. What does R-U-M mean? (can't mean "Range Usage Metadata" which was finally coined range index BRIN)?
We chose RUM just because there are GIN and VODKA :) But some people already suggested several meanings like Really Useful iMdex :) We are open for suggestion.