Hi Martin,

Assuming an average triple size of 30 bytes, 150 million triples would require 
4.5GB of memory ie 562500  (4.5GB / 8K) NumberOfBuffers. Although also how many 
triples are there in the Virtuoso Quad stores as that would determine the size 
required for hosting to the database working set in memory.

What is the Virtuoso version being used, which can be determined by running the 
command:

        virtuoso-t -?

Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc.      //              http://www.openlinksw.com/
10 Burlington Mall Road, Suite 265, Burlington MA 01803
Weblog   -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter  -- http://twitter.com/OpenLink
Google+  -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers

On 23 Jan 2012, at 13:59, Martin Gerlach wrote:

> Hi Hugh,
> 
> I tried as described on the Web page. For a while, memory usage remained 
> constant, but after a while it suddenly rose and broke:
> 
> 14:55:30 ERROR: Memory low! Using memory reserve to terminate current 
> activities properly
> 14:55:30 ERROR: Current location of the program break 13070086144
> 14:55:30 ERROR: GPF: gate.c:1464 loop in registered cursors
> 
> Any recommendation on the NumberOfBuffers settings for that operation?
> 
> Cheers,
> Martin
> 
> On 23.01.2012 12:43, Hugh Williams wrote:
>> 
>> Hi Martin,
>> 
>> Please see the following tip on rename graphs in Virtuoso, the key for large 
>> graphs being to perform the operation in auto-commit mode (log_enable(3)) to 
>> avoid excessively sized transaction log depleting memory:
>> 
>> http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtTipsAndTricksGuideRenameGraph
>> 
>> Best Regards
>> Hugh Williams
>> Professional Services
>> OpenLink Software, Inc.      //              http://www.openlinksw.com/
>> 10 Burlington Mall Road, Suite 265, Burlington MA 01803
>> Weblog   -- http://www.openlinksw.com/blogs/
>> LinkedIn -- http://www.linkedin.com/company/openlink-software/
>> Twitter  -- http://twitter.com/OpenLink
>> Google+  -- http://plus.google.com/100570109519069333827/
>> Facebook -- http://www.facebook.com/OpenLinkSoftware
>> Universal Data Access, Integration, and Management Technology Providers
>> 
>> On 23 Jan 2012, at 10:49, Martin Gerlach wrote:
>> 
>>> Hi,
>>> 
>>> I'd like to rename a graph with about 150 million triples in Virtuoso 
>>> Open Source 6.1
>>> 
>>> The Virtuoso db file has 16GB.
>>> 
>>> Which is the best way to rename such a big graph? Going through 
>>> Conductor/RDF/Graphs/rename or using isql?
>>> 
>>> Which are the required buffer sizes for renaming the graph?
>>> 
>>> I tried with 2,3 Mio max buffers and max dirty buffers (18 GB which is 
>>> 75% of the machine's RAM), but Virtuoso crashed after this log output:
>>> 
>>> 11:37:36 ERROR: Memory low! Using memory reserve to terminate current 
>>> activities properly
>>> 11:37:36 ERROR: Current location of the program break 19991629824
>>> 11:37:36 ERROR: GPF: gate.c:1464 loop in registered cursors
>>> 
>>> Cheers,
>>> Martin
>>> 
>>> 
>>> 
>>> ------------------------------------------------------------------------------
>>> Try before you buy = See our experts in action!
>>> The most comprehensive online learning library for Microsoft developers
>>> is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
>>> Metro Style Apps, more. Free future releases when you subscribe now!
>>> http://p.sf.net/sfu/learndevnow-dev2
>>> _______________________________________________
>>> Virtuoso-users mailing list
>>> [email protected]
>>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>> 
> 
> -- 
> Martin Gerlach
> Senior Softwareentwickler
> Research
> 
> Neofonie GmbH
> Robert-Koch-Platz 4
> 10115 Berlin
> 
> T +49.30 24627 413
> F +49.30 24627 120
> [email protected]
> http://www.neofonie.de
> 
> Handelsregister
> Berlin-Charlottenburg: HRB 67460
> 
> Geschäftsführung
> Thomas Kitlitschko
> Dr. Mario Lenz
> 
> ------------------------------------------------------------------------------
> Try before you buy = See our experts in action!
> The most comprehensive online learning library for Microsoft developers
> is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
> Metro Style Apps, more. Free future releases when you subscribe now!
> http://p.sf.net/sfu/learndevnow-dev2_______________________________________________
> Virtuoso-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Attachment: smime.p7s
Description: S/MIME cryptographic signature

Reply via email to