On Thu, Aug 25, 2011 at 11:08 PM, Heikki Linnakangas < heikki.linnakan...@enterprisedb.com> wrote:
> Could you share the test scripts, patches and data sets etc. needed to > reproduce the tests you've been running? I'd like to try them out on a test > server. > 1) I've updated links to the datasets on the wiki page. 2) Script for index quality testing fastbuild_test.php is in the attachment. In order to run it you need PHP with pdo and pdo_pgsql modules. Also plantuner moduler is required (it is used to force planer to use specific index). After running that script following query returns relative score of index quality: select indexname, avg(count::real/(select count from test_result a2 where a2.indexname = 'usnoa2_idx3' and a2.predicate = a1.predicate and a2.tablename = a1.tablename)::real) from test_result a1 where a1.tablename = 'usnoa2' group by indexname; where 'usnoa2' - table name, 'usnoa2_idx3' - name of index which quality was assumed to be 1. 3) Patch which makes plantuner work with HEAD is also in attachment. 4) Patch with my split algorithm implementation is attached. Now it's form is appropriate only for testing purposes. 5) For indexes creation I use simple script which is attached as 'indexes.sql'. Also, similar script with different index names I'm running with my split patch. Feel free to ask questions about all this stuff. ------ With best regards, Alexander Korotkov.
fastbuild_test.php.gz
Description: GNU Zip compressed data
plantuner.patch.gz
Description: GNU Zip compressed data
my_split.patch.gz
Description: GNU Zip compressed data
select pg_stat_statements_reset(); set log_statement_stats = on; set synchronize_seqscans = off; create index uniform_idx1 on uniform using gist(point) with (buffering=on); create index uniform_idx2 on uniform using gist(point) with (buffering=auto); create index uniform_idx3 on uniform using gist(point) with (buffering=off); create index usnoa2_idx1 on usnoa2 using gist(point) with (buffering=on); create index usnoa2_idx2 on usnoa2 using gist(point) with (buffering=auto); create index usnoa2_idx3 on usnoa2 using gist(point) with (buffering=off); create index usnoa2_shuffled_idx1 on usnoa2_shuffled using gist(point) with (buffering=on); create index usnoa2_shuffled_idx2 on usnoa2_shuffled using gist(point) with (buffering=auto); create index usnoa2_shuffled_idx3 on usnoa2_shuffled using gist(point) with (buffering=off);
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
