pe1uca , 1 year ago

I’m running it in the smallest VPS of vultr with 25GB of disk.
This instance only has 3 users, with me being the only active. It says it’s been up for almost a month and I’ve only used 3GB.

Here are the docker volumes which have the actual data of your instance, and from inside the DB the biggest table is the one called activity which the devs said it’s only sometimes used to validate the data, but could be truncated if needed (there’s a schedule task which only keeps up to 6 months).
Also the thing to have in mind is to properly configure the logs of whichever installation guide you follow.
After that I’ve seen other admins say the next biggest is the media uploaded (from bigger instances).

<pre style="background-color:#ffffff;">
<span style="color:#323232;">$ du -h --max-depth</span><span style="font-weight:bold;color:#a71d5d;">=</span><span style="color:#323232;">1
</span><span style="color:#323232;">640K    ./pictrs
</span><span style="color:#323232;">3.2G    ./postgres
</span><span style="color:#323232;">3.2G    .
</span><span style="color:#323232;">
</span><span style="color:#323232;">lemmy</span><span style="font-weight:bold;color:#a71d5d;">=</span><span style="color:#183691;"># </span><span style="color:#323232;">select
</span><span style="color:#323232;">  table_name,
</span><span style="color:#323232;">  pg_size_pretty(pg_relation_size(quote_ident(table_name))),
</span><span style="color:#323232;">  pg_relation_size(quote_ident(table_name))
</span><span style="color:#323232;">from information_schema.tables
</span><span style="color:#323232;">where table_schema = </span><span style="color:#183691;">'public'
</span><span style="color:#323232;">order by 3 desc</span><span style="font-weight:bold;color:#a71d5d;">;
</span><span style="color:#323232;">         table_name         </span><span style="font-weight:bold;color:#a71d5d;">| </span><span style="color:#323232;">pg_size_pretty </span><span style="font-weight:bold;color:#a71d5d;">| </span><span style="color:#323232;">pg_relation_size
</span><span style="color:#323232;">----------------------------+----------------+------------------
</span><span style="color:#323232;"> activity                   </span><span style="font-weight:bold;color:#a71d5d;">| </span><span style="color:#323232;">2187 MB        </span><span style="font-weight:bold;color:#a71d5d;">|       </span><span style="color:#323232;">2292867072
</span><span style="color:#323232;"> comment                    </span><span style="font-weight:bold;color:#a71d5d;">| </span><span style="color:#323232;">56 MB          </span><span style="font-weight:bold;color:#a71d5d;">|         </span><span style="color:#323232;">58212352
</span><span style="color:#323232;"> person                     </span><span style="font-weight:bold;color:#a71d5d;">| </span><span style="color:#323232;">48 MB          </span><span style="font-weight:bold;color:#a71d5d;">|         </span><span style="color:#323232;">50307072
</span><span style="color:#323232;"> comment_like               </span><span style="font-weight:bold;color:#a71d5d;">| </span><span style="color:#323232;">45 MB          </span><span style="font-weight:bold;color:#a71d5d;">|         </span><span style="color:#323232;">47161344
</span><span style="color:#323232;"> post_like                  </span><span style="font-weight:bold;color:#a71d5d;">| </span><span style="color:#323232;">22 MB          </span><span style="font-weight:bold;color:#a71d5d;">|         </span><span style="color:#323232;">22781952
</span><span style="color:#323232;"> comment_aggregates         </span><span style="font-weight:bold;color:#a71d5d;">| </span><span style="color:#323232;">14 MB          </span><span style="font-weight:bold;color:#a71d5d;">|         </span><span style="color:#323232;">14811136
</span><span style="color:#323232;"> post                       </span><span style="font-weight:bold;color:#a71d5d;">| </span><span style="color:#323232;">13 MB          </span><span style="font-weight:bold;color:#a71d5d;">|         </span><span style="color:#323232;">13623296
</span>