Re: Slides for PGCon2016; "FTS is dead ? Long live FTS !" - Mailing list pgsql-general
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/rum1. 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.
:Stefan, co-organizer of Swiss PGDay2016-05-29 11:29 GMT+02:00 Andreas Joseph Krogh <andreas@visena.com>:På lørdag 28. mai 2016 kl. 23:59:55, skrev Oleg Bartunov <obartunov@gmail.com>:On Thu, May 26, 2016 at 11:26 PM, Andreas Joseph Krogh <andreas@visena.com> wrote:Hi.Any news about when slides for $subject will be available?I submitted slides to pgcon site, but it usually takes awhile, so you can download our presentation directly http://www.sai.msu.su/~megera/postgres/talks/pgcon-2016-fts.pdf
There are some missing features in rum index, but I hope we'll update github repository really soon.This is simply amazing!I want to run 9.6 beta in production right now because of this:-)Hats off guys, congrats to PostgresPro, and huge thanks!!--Andreas Joseph KroghCTO / Partner - Visena ASMobile: +47 909 56 963
Attachment
pgsql-general by date: