The reason for this is that we have a fixed record size and do not index records (the id is the position of the record). This improves speed and the space will be reclaimed/re-used once the id is reused.
Another thing is that in most use-cases the data size grows more than it decreases so this has never been a problem. -Johan On Thu, Feb 25, 2010 at 2:53 PM, Laurent Laborde <[email protected]> wrote: > this a normal behaviour on most RDBMS too. > The size won't decrease until you do some kind of "vacuum full". > At best, the space will be reused when reinserting new data. > > -- > Ker2x > > 2010/2/25 Miguel Ángel Águila <[email protected]>: >> Hi, >> >> in this part I agree with you but if I had deleted 310.000 nodes from >> 325.000 from de database I think that the database should decrease its >> spaces. Before delete the space of the database was 432 MB and after the >> delete the database grown until 474 MB, also storing the indexes for >> reusing later I think that it should decrease. >> >> I don't understand why works in this way. >> Thanks. >> >> Mike >> >> >> El jue, 25-02-2010 a las 13:18 +0100, Johan Svensson escribió: >>> Hi, >>> >>> Yes those files holds ids that can be reused. If you startup again and >>> create 310k nodes the id file will shrink and the db file will not >>> change in size. >>> >>> Regards, >>> -Johan >>> >>> 2010/2/25 Miguel Ángel Águila <[email protected]>: >>> > Helo, >>> > I'm doing a delete operation, in this case I'm deleting 310.000 nodes >>> > from 325.000 nodes. I can delete and after that all works well because >>> > the nodes when I get them only appears the no deleted nodes, but the >>> > size of the folder that contains neo4j database has grown. Specifically >>> > has grown the following files: >>> > >>> > - Folder lucene. >>> > - neostore.nodestore.db.id >>> > - neostore.propertystore.db.id >>> > - neostore.propertystore.db.strings.id >>> > - neostore.relationshipstore.db.id >>> > >>> > I expect, you can help me. >>> > Thank you. >>> > >>> > Mike _______________________________________________ Neo mailing list [email protected] https://lists.neo4j.org/mailman/listinfo/user
