Does deleting nodes and relationships immediate cut down Neo4j disk usage size?

[Ray Chengr]

We continue to add nodes and relationships to our Neo4j 3.0.3. At some point our disk will be full. One way is to remove old nodes and relationships when disk is approaching to, say 80%, full. Does deleting nodes and relationships immediate cut down Neo4j disk usage size, or do we need to restart Neo4j to see less disk usage size?
Thanks!

[Michael Hunger]

If you restart after deletions the freed records will be reused.

To compact your store you can use my store-utils tool: https://github.com/jexp/store-utils

Cheers, Michael

Am 28.08.2016 um 09:48 schrieb Ray Chengr <chen...@gmail.com>:

We continue to add nodes and relationships to our Neo4j 3.0.3. At some point our disk will be full. One way is to remove old nodes and relationships when disk is approaching to, say 80%, full. Does deleting nodes and relationships immediate cut down Neo4j disk usage size, or do we need to restart Neo4j to see less disk usage size?
Thanks!

--
You received this message because you are subscribed to the Google Groups "Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email to neo4j+un...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Ray Chengr]

Hi Michael,

(1) I didn't restart Neo4j 3.0.3 after I deleted about 3,000,000 relationships last night.

'du' showed neostore.propertystore.db and neostore.propertystore.db.arrays stay the same size after a whole night's Neo4j creations of nodes and relationships without restarting Neo4j 3.0.3.

% du neostore.propertystore.db*
15967220        neostore.propertystore.db              
28139264    neostore.propertystore.db.arrays
(in KB)

It seems to me the disk storage spaces for relationship's properties and property arrays are being reused without a Neo4j restart. Is this right?

(2) Does your store-utils tool  copy the exist Neo4j DB to a new location in order to compact the storage on the new Neo4j DB?

Thanks!
Ray

[Michael Hunger]

Am 28.08.2016 um 23:50 schrieb Ray Chengr <chen...@gmail.com>:

Hi Michael,

(1) I didn't restart Neo4j 3.0.3 after I deleted about 3,000,000 relationships last night.

'du' showed neostore.propertystore.db and neostore.propertystore.db.arrays stay the same size after a whole night's Neo4j creations of nodes and relationships without restarting Neo4j 3.0.3.

% du neostore.propertystore.db*
15967220        neostore.propertystore.db              
28139264    neostore.propertystore.db.arrays
(in KB)

It seems to me the disk storage spaces for relationship's properties and property arrays are being reused without a Neo4j restart. Is this right?

Yes, property blocks are reused immediately only node and relationship-blocks are only reused after restart.

(2) Does your store-utils tool  copy the exist Neo4j DB to a new location in order to compact the storage on the new Neo4j DB?

Yes it does.

[Ray Chengr]

Great! Thanks  a  lot Michael!
Ray