[FEATURE] periodic.iterate() does not release any memory

memgraph / mage

MAGE - Memgraph Advanced Graph Extensions :crystal_ball:

Apache License 2.0

238 stars 23 forks source link

[FEATURE] periodic.iterate() does not release any memory #474

Open Josipmrden opened 1 month ago

Josipmrden commented 1 month ago

Because periodic.iterate is started, whenever there are deltas created, it will not periodically release any memory because it is the first transaction that started, and because we are in SNAPSHOT_ISOLATION isolation level, deltas can't be released.

Possible solutions to discuss:

release some deltas in the read_committed mode
implement periodic commit