Expiration period

Fri, 27 Oct 2023 00:42:26 +0200

adminsforum@hubzilla.org

Alexandre Hannud Abdo wrote the following post Fri, 27 Oct 2023 00:42:26 +0200

Expiration period

Ni! Hi folks,
I've set content "Expiration period" in "Admin - Site" to 366.
I thought this would expire all content older than a year.
But I haven't (yet) seen any decrease in the count of my 'item' table.
Am I missing something?

Fri, 03 Nov 2023 22:49:36 +0100

Alexandre Hannud Abdo

aleabdo@hubzilla.com.br

Well, it seems the item table cleared up after a few days, no idea why the delay. But the disk space used by the database did not change. For that I had to dump and restore it.

Sun, 12 Nov 2023 06:29:16 +0100

Scott M. Stolz

scott@loves.tech

I believe the database reserves space for future growth, so even if you delete stuff in the database, it does not resize immediately. There are ways to force a resize based on the current data in the database, but I have not used that in awhile, so I forgot how to do it.