Spyke

Syndicated from the fediverse. Read and engage on the original instance.

View original on dzle125.stream
main·DZLE 125 Mainbydosesingko

DZLE Advisory - Reclaimed 20% of disk space by deleting records in the Activity Table

Since operating DZLE lemmy instance for 18 days, almost 5 GB of the activity table has been accumulated, Had to go inside the postgres container to delete and vacuum those records before July 19. Now, the table size is about 1.8 GB.

Here is the current size of the tables as of this posting.

tablesize (MB)
activity1834MB
comment_like147MB
comment107MB
post_like80MB
person67MB
comment_aggregates26MB
post13MB

It is still economical to run a small lemmy instance, but this will probably become problematic should the fediverse gets more active.

View original on dzle125.stream
1

No replies yet

No comments on the original post yet.
DZLE Advisory - Reclaimed 20% of disk space by deleting records in the Activity Table | Spyke