Hi Alexander,
Glad to hear log_enable worked for you and I have created the following tip for
all’s benefit on how to delete large graphs:
http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtTipsAndTricksGuideDeleteLargeGraphs?
With regards to the vacuum function did you run a checkpoint afterwards and
restart the database. The vacuum function make a best effort at compacting the
database tables and indexes but is not always guaranteed to, although I
certainly would not expect it to result in a 50% increase in database size ?
Probably the best way to compact the database assuming you only have data in
the Quad store would be to dump all graphs and reload into and empty database
as detailed at:
http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtDumpLoadRdfGraphs
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 11 Jun 2011, at 08:57, Alexander Sidorov wrote:
> log_enable 3 worked like a charm. Graph contains zero triples now. After that
> I tried to run vacuum() to make the size of my database less, but after it
> had finished its work, the size became even more (was 4.8gb, now 6.8gb).
>
> 2011/6/11 Ivan Mikhailov <[email protected]>
> Hi Alexander
>
> > log_enable(3,1);
> > delete from rdf_quad where g = iri_to_id (‘graph-name’);
>
> Note that this will not even try to remove free-text index data for this
> graph.
>
> Best Regards,
>
> Ivan Mikhailov
> OpenLink Software
> http://virtuoso.openlinksw.com
>
>
>
> ------------------------------------------------------------------------------
> EditLive Enterprise is the world's most technically advanced content
> authoring tool. Experience the power of Track Changes, Inline Image
> Editing and ensure content is compliant with Accessibility Checking.
> http://p.sf.net/sfu/ephox-dev2dev_______________________________________________
> Virtuoso-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
