I load a large rdf dataset into virtuoso, it used about 5GB disk space shown in virtuoso.db, and then I use the isql command:

SQL> SPARQL CLEAR GRAPH <graph-name>;

after remove all triples , the file virtuodo.db is still hold on 5GB disk space?

how can I get back my disk space?

asked 11 Nov '12, 13:01

summerjapan's gravatar image

summerjapan
133
accept rate: 0%


The Virtuoso Server will not release pre-allocated block thus the database will not reduce in size. The only way to recover is to probably dump and restore the database, essentially building a new database.

The Virtuoso vacuum function can be used compact tables and index and improve performance but it will not reclaim disk space, see:

http://docs.openlinksw.com/virtuoso/dbadm.html#indexdefragm

link

answered 11 Nov '12, 21:06

HughWilliams's gravatar image

HughWilliams
941
accept rate: 33%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×853
×278
×194

Asked: 11 Nov '12, 13:01

Seen: 912 times

Last updated: 11 Nov '12, 21:06