X-Git-Url: http://sigaev.ru/git/gitweb.cgi?p=ftsbench.git;a=blobdiff_plain;f=README;h=e1a28f020b67fe25520363c894e14c6f7d680e19;hp=8960c0b948d5a15224d670189b9d59e362bef6a3;hb=HEAD;hpb=e4c06c34627eb24593536e72cda80101b28ac394 diff --git a/README b/README index 8960c0b..e1a28f0 100644 --- a/README +++ b/README @@ -1,9 +1,8 @@ Full-text search benchmark. -Before compilating, edit Makefile for RDBMS set and -paths to its. +Set RDBMS and paths in Makefile before compilation. -Init example: +Initialization example: ./ftsbench -i -n 10000 -f gin -b pgsql -d contrib_regression Benchmark example: @@ -19,6 +18,21 @@ MySQL prerequisite: tested on 5.0.24a ./configure --enable-thread-safe-client --with-pthread +SQL mode (output may be redirected to file or database): +% ftsbench -S | psql postgres +% ftsbench -i -n 10 -f gin -s 17 -d contrib_regression +INSERT INTO fb_create (id, rdbms, f_gin, f_gist, f_func, rows, elapsed) VALUES (17, 'pgsql', 't', 'f', 'f', 10, 0.528075); +% ftsbench -c 2 -n 2 -f gin -s 17 -d contrib_regression +INSERT INTO fb_search (id, f_and, f_or, nclients, nqueries, nres, elapsed) VALUES (17, 't', 'f', 2, 2, 0, 0.063508); +% ftsbench -c 2 -n 2 -f gin -s 17 -r -d contrib_regression +INSERT INTO fb_row (id, f_and, f_or, nclients, nres, elapsed) VALUES (17, 't', 'f', 2, 0, 0.039024); +INSERT INTO fb_row (id, f_and, f_or, nclients, nres, elapsed) VALUES (17, 't', 'f', 2, 1, 0.009069); +INSERT INTO fb_row (id, f_and, f_or, nclients, nres, elapsed) VALUES (17, 't', 'f', 2, 0, 0.061368); +INSERT INTO fb_row (id, f_and, f_or, nclients, nres, elapsed) VALUES (17, 't', 'f', 2, 3, 0.003654); + + + +Notice: Although ftsbench is covered by BSD license redistribution of rand.c and finnegan.c is prohibited without the permission of J. Zobel (jz at cs.rmit.edu.au).