!Friendica Developers
!Friendica Developers
The post-tag and post-user tables are extremely large at 140GB and 145GB and continue to grow. It seems as if the two tables have lost the ability to delete data. The optimisation via OPTIMIZE TABLE takes a correspondingly long time. I can also reproduce this behaviour on two other, independent nodes, although not to the same extent (fewer users).
Question: is there a kind of clean-up script that I can run from time to time to delete content that has long since expired?