Re: [Virtuoso-users] creating indexes with Virtuoso 7.0.0

2013-10-15 Thread Hugh Williams
Hi Erich, Ah, you should not really be using that bitmap index with the default v7 indexes which are for column store. I tried that myself just now and my server crashed on Mac loading datasets, which it should not even if the indexes are mismatched, so I have reported to development. The docs

Re: [Virtuoso-users] creating indexes with Virtuoso 7.0.0

2013-10-14 Thread Erich Bremer
Hi Hugh, Reason #1: The Virtuoso tuning guide suggested: "If predicate and graph are given but subject is not, then it is sometimes useful to add: CREATE BITMAP INDEX RDF_QUAD_PGOS ON DB.DBA.RDF_QUAD (G, P, O, S) PARTITION (O VARCHAR (-1, 0hex));" The instructions did not indicate for this

Re: [Virtuoso-users] creating indexes with Virtuoso 7.0.0

2013-10-14 Thread Hugh Williams
Hi Erich, Why are you creating these additional indexes and if you did were the defaults dropped first ? What does the the following query return: STATISTICS DB.DBA.RDF_QUAD; Which should return a list of indexes on the RDF_QUAD table ... As indicated in the performance tuning guide th